I just built an Umbraco website. This uses a not-that-small SQL Server db. I copied this DB using the export data function built in in SQL Server 2008.
This copies all the tables and their content but it sets (for the one table i know) the Identity(1,1) column to "int". This way my umbraco installation fails over this.
As I tried to change the column type to identity, obviously I can't edit the columns. Even if there was a way to do this manually, I'd still have to change most of the tables in the new database.
Is there some option or so I missed when copying? I'd like to make it copy with the included identity.
I tried backup, and restore but my SQL server edition are not exactly the same. The one is x86 and the other is x64, which is giving me compatibility issues.
Thanks in advance!