MS SQL Server 2012
Hi, friends. I could use a little help.
I imported data tables from MS SQL Server 2005 on a server at HostMySite.com, into MS SQL Server 2012 on a server at viviotech.net. However, the imported data tables are not quite right. There are two problems with each table:
1) no primary key is set -- for example, PageID is no longer marked Primary Key
2) I cannot set "Is Identity" to "Yes", or set Identity Increment to a value of "1"
When I set these things manually and try to save the design of the table, I get an error: "Saving changes is not permitted. The changes you have made require the following tables to be dropped and recreated. You have either made changes to a table that can't be recreated or enabled the option Prevent saving changes that require the table to be recreated."
I definitely need a Primary Key in my tables, and an Identity Increment value of 1.
Have you seen this problem before? I attach a screenshot.
Is there a way to import data into SQL Server 2012, and preserve Primary Key and "Is Identity" settings?
When I import tables, I use the MS SQL Server 2012 Import and Export Data Tool (64-bit).
Thank you very much for your help.