Tuesday, March 20, 2012

Copy Database Wizard (MS SQL 2005)

When I use the "Copy Database Wizard" everything works fine, but the "Identity Specification" is changed in the new database.

Source database (original):
Column Name = HTML_ID
Data Type = int
Identity Specification = Yes
Is Identity = Yes
Identity Increment = 1
Identity Seed = 1

Destination database (copy):
Column Name = HTML_ID
Data Type = int
Identity Specification = No
Is Identity = No
Identity Increment =
Identity Seed =

Why? Is this a feature or a bug?

I am seeing the same. This is a real problem.|||

I have found the following from Peter Shadddow of MSFT in another forum from Nov 2005:

This is a known issue with TransferData(), which is slated to be fixed in service pack 1. ScriptTransfer generates the correct T-SQL for identity columns. If you are only moving schema, then ScriptTransfer() should meet your needs.

Peter

No comments:

Post a Comment