April 28, 2009 at 5:23 am
Hy.
I want to copy all the tables from a database to another, but leave the old stored procedures and functions.
If I use back up's I can't select to restore only the tables.
I can't use import data because I need to keep all the primary , foreign keys, autoincrement columns etc.
Help 🙂
April 28, 2009 at 9:39 am
Script the tables and create them in the destination database, then use the Import/Export Wizard to copy the data. Or create an SSIS package with a Transfer SQL Server Objects Task.
Greg
April 28, 2009 at 11:17 pm
If I have an autoincrement column (is identity) the import/export wizard raise an error.
April 29, 2009 at 8:55 am
For the tables that have identity columns, click on the "Edit Mappings..." button in the Wizard and check the "Enable identity insert box. This will disable the identity increment on the destination table and insert the values from the source table.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply