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

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.sqlpass.org


"Simon Middlemiss" <bob (AT) flemming (DOT) net> wrote