Friday, March 30, 2012

Loss of Column properties when exporting with DTS

Exporting a sql 2000 database from one sql 2000 server to another. I am using DTS import/export Wizard. The data transfers fine but column properties such as identity = yes or default value = (getdate()) are lost in transfer. What am I missing??May check this DB JOurnal (http://www.databasejournal.com/features/mssql/article.php/1499481) article.

No comments:

Post a Comment