How to update a new sql 2008 r2 database from an older sql 2008 r2 indexed database

I have a program that has used the same sql 2008 r2 database for some years. It is a fairly simple layout than uses one of its columns as (is indentity) (autonumber by 10). Each time a new record is added it produce a new number. This is then used by other tables as a relational key.

I have made a major update to the program and require the old data to be imported into the new database table. The problem is that if I insert the old data into the new one the index increment will be consecutive. This problem is that in the past occasionally a record will be deleted so the numbers won't be consecutive.

How do I move the old table to the new database and preserve in indexed number in the old. The new table will still need to be indexed.

Is there a way to copy the old table to the new and preserve the indexed number?
milkwoodAsked:
Who is Participating?
 
Matt BowlerDB team leadCommented:
0
 
milkwoodAuthor Commented:
Just the job
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.