October 27, 2004 at 8:44 am
I have a table that I was restoring from a backup that was less then an hour old. The table has a primary key set and it generates succesive ID's for every entry. None carried over. How do you get this to DTS successfully?? Thank for the replies.
October 27, 2004 at 10:21 am
I'm making some assumptions about your situation, so please correct me if I'm wrong.
I assume you're using the DTS import/export wizard and that the primary key of your
table is an identity column.
After setting the source and destination databases, where you choose to
a) copy table or view
b) use a query to specify data to copy
c) copy objects and data between SQL Server databases
If you choose c), and opt to create the destination object, the table will be created exactly the same as the source table, including the identity property.
If you choose a), click on the elipse in the 'Transform' column of the next screen. Check 'Create destination table', check 'Enable Identity Insert', click on the 'Edit SQL' button, and modify the create script by adding the identity property to the primary key column. Then, continue with the wizard as usual.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply