Hello there,
I am using sql 2000 dts package to migrate a databse to SQL Server 2005, everything works except for identity columns, SQL Server reorder the columns, and this breaks the referential integrity. Is there a way to stop that? Your help is appreciated.
Hi,
hard to tell why this happens, becasue you didn′t provide any information about the settings of your dts package. One thing would to not migrate the identity columns and
-treat them like integer columns / turn on the identity property later (With creating a new column, because there is no "identity" property) OR
-Allow identity insert on those columns and include them in the import of the tables.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment