I have DB, and want to move it to another PC.
I use MSSQL Publishing Wizard or SQL Server Management studio to create dump.
There is some problem after I executed dumped queries.
I get error "Invalid tuple descriptor" when trying to insert something.
I can upgrade domain, it solves this problem.
But it seems that autoincremented IDs reset theirs last inserted value after that.
How can I make correct dump of DO database?
PS. Sorry for my English :)
With SQL server management studio, you can right click on a database and select "Tasks" then "Backup..." to get a .bak file.
You can then restore this file on another server.
answered Oct 12 '10 at 10:11
You must ensure all
These tables are used to emulate sequences, that are supported by other database (and described in SQL-99), but aren't supported by SQL.
Ok, I understand. Here is sql, generated by Management Studio:
Both seed and increment = 1.
But I can't find option that will include seed and increment values in dump.
Could you recommend some tool to make correct dumps?
answered Oct 12 '10 at 06:01