Archive | MS SQL Server RSS feed for this section

Transfer SQL Server Database Preserving Keys and Identities

Posted on March 30, 2006 by in MS SQL Server

If you try to transfer a database from one SQL Server to another using the Enterprise Manager data transfer wizard, you may notice that your primary key and identity properties do not transfer correctly. To transfer these, you have to use the “Transfer Objects” and change a few of the defaults. If you just accept [...]

Leave a comment • Continue Reading →