October 26, 2005 at 3:09 am
I have been trying to move a table to a new database, using the import wizard, I have tried all three options available, but the id column is starting at a number that bears no relation to the value of the id column in the source table, how can i force the new table to accept the original id column values?
October 26, 2005 at 4:06 am
Don't know if this will help but..
If i want to preserve the original numbering when copying to a new table that has an identity column, i 'switch off' the identity setting, copy the table and then switch the identity back on.
Hope that helps your situation
Growing old is mandatory, growing up is optional
October 26, 2005 at 10:12 am
Paul,
Use the Copy tables and views option. On the Column Mappings tab of the import wizard, you'll find a check box that says, "Enable identity insert". Check the box and finish the wizard. That will copy the identity column values from the source table.
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply