Re: data extraction/mapping between two databases

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 18:08:34 +0100

I'd just understand the data, and then populate tables manually, using
INSERT statements, to populate the primary key and foreign key tables. 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Mani" <mani@spamthis@evikasystems.com> wrote in message
news:eACFDzamEHA.1904@TK2MSFTNGP09.phx.gbl...
Hi ,
just wondering, whats the easiest way to map about 10000 rows from database
a (old) to database b.
the complexity is that the structure is completely different,  database b is
more normalized. has relationships maintained..where as database a has
everything in one table ..So I have to map one column (choose distinct rows)
and move to datbase b.new table...
I did try DTS for couple of them..but seems tedious and never ending..
Whats the easiest way to do this? any OR tools ?? anything ...
Thanks,

Relevant Pages

  • Re: Automatically Creating blank records
    ... related directly or indirectly to a table called [Training Course] ... It is a training course database. ... the record with the Primary key of the table and the foreign key of ...
    (microsoft.public.access.tablesdbdesign)
  • common fields
    ... If I have two tables, each containing "user_ID" as the primary key, what ... code do I need to write so that when I populate the "user_ID" in one, ... One table contains basic user information, the ... database, not an auto-generated number) to populate both tables. ...
    (microsoft.public.access.formscoding)
  • Re: problem using identity column as primary key
    ... >> I am thinking of creating an identity column to use it as primary key ... More and more programmers who have absolutely no database training are ... the gap in the sequence is not filled in and the sequence ... vin CHARNOT NULL REFERENCES Motorpool); ...
    (microsoft.public.sqlserver.programming)
  • Re: Tables and inserting rows
    ... endorsements would populate for that 1 vehicle. ... Is it possible to rename the bookmark or do I have to use the other option ... Dim myDataBase As Database ... Dim myActiveRecord As Recordset ...
    (microsoft.public.word.vba.general)
  • Re: Tables and inserting rows
    ... I have the main template and then am inserting a document which has all the ... Dim myDataBase As Database ... Dim myActiveRecord As Recordset ... 'Add a row to the table and populate the cells in that row with the ...
    (microsoft.public.word.vba.general)