No Identity Specification on DB Copy in SQL Mgmt Studio?
So slowly but surely some of our databases are making it from SQL Server 2000 to SQL Server 2005. In that process, some of our databases are moved using the quick 'copy' method. Simply right click on the DB in SQL Management Studio, go to tasks, select Copy Database.
However, on my setup:
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.1.2600
When moving from a SQL 2000 -> 2005 copy, the new database fails to maintain the 'identity specification' as YES on the primary keys of my tables. Subsequently, I had to manually add the identity spec. back on about 10 tables. Lame!
I wanted to report this bug to Microsoft, but figuring out how to report a bug is like pulling teeth! There's no general public bug submission form; you can go through their 'connect' program but its a huge pain in the ass. If they want to write better software, Microsoft should at least give me a bug report form.