Post reply

Copying a table with an identity column between databases

  • October 26, 2005 at 3:09 am

    #363988

    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

    #600066

    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

    #600281

    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