Peter|||So what is the recommended way to copy databases from SQL 2000 to SQL 2005?
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:
Post Comments (Atom)
No comments:
Post a Comment