Hello everyone. 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 :) |
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? |