migration with link tables...

migration with link tables...

Post by Simon Midd » Thu, 13 Nov 2003 19:43:50


We are migrating an old database structure to the new structure and I am
having problems becuase we have added a link table between two tables as
shown below. Could someone tell me how I would use DTS to go about this
migration?

Cheers

Simon

-------------------

Old structure

[TABLE1]
Table1ID
Table2ID
Etc

[TABLE2]
Table2ID
Etc

New Structure
[TABLE1]
Table1ID

[TABLE2]
Table2ID

[LINKTABLE]
Table1ID
Table2ID
 
 
 

migration with link tables...

Post by Allan Mitc » Thu, 13 Nov 2003 23:47:34

Migrate Table 1 -- Table 1 (Table 1 ID only)
Migrate Table 2 -- Table 2
Migrate Table 1 again -- Link table, both columns

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.yqcomputer.com/