Perfroming DTS Wizard

[PaulHamill]

All

Does anyone know why when I run the DTS Wizard in SQL Server 7.0 to copy tables from one DataBase to another, that settings like Primary Keys and Identities are not carried forward. Is there a reason for this and if so is there a way around this

Thanking you all in advance

 

[tlbroadbent]

When you use the wizard, make sure you choose the option, "Transfer objects and data between SQL Server 7.0 databases." Then make sure the options for copying indexes, keys, etc. are set on.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm