Timeline for SQL Server - Copy data from one database to another - identical tables, new identity values needed
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 31, 2014 at 8:08 | review | Suggested edits | |||
| Jan 31, 2014 at 10:04 | |||||
| Jan 30, 2014 at 13:30 | comment | added | Jordan | I only need the data as the schemas are identical. | |
| Jan 30, 2014 at 13:28 | comment | added | Jordan | Thanks, both databases are on the same instance of Sql Server so that's no problem. The server is 2008 R2, though I want to upgrade to 2012 soon. In the Generate Scripts tool, do I select Tables, then Data Only? Which option do I change to force the script to create new identities for everything, 'Script unique keys', 'Script primary keys' ? | |
| Jan 30, 2014 at 8:47 | history | answered | sairam | CC BY-SA 3.0 |