Peter|||So what is the recommended way to copy databases from SQL 2000 to SQL 2005?
Showing posts with label incrementing. Show all posts
Showing posts with label incrementing. Show all posts
Wednesday, March 7, 2012
Bug in Copy database routine
I copied some databases from a SQL 2000 server to a SQL 2005 server. All the tables in the databases with auto incrementing identity columns (not for replication) had the identity information removed from the table definition. I used the SQL Management Object method.This is a known issue in SMO that is expected to be fixed in Server Pack 1.
Subscribe to:
Posts (Atom)