Why do I loose PK and Identity when I DTS a table?

[meckeard]

All,

Whenever I use DTS to copy a table from my local server to a remote one, my PK/Identity fields loose the PK and Identity setting.

Anyone know what I can do to prevent this from happening?

Thanks,
Mark

 

[mrdenny]

Edit the transformations and tell it not to drop and recreate the table. You want to append to the already existing table.

If you are creating a new table, you'll need to add code after the fact to add this info in. DTS doesn't copy it across.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)