Solved

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

Posted on 2013-06-18
2
233 Views
Last Modified: 2013-06-19
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?
0
Comment
Question by:milkwood
2 Comments
 
LVL 9

Accepted Solution

by:
MattSQL earned 500 total points
Comment Utility
0
 

Author Closing Comment

by:milkwood
Comment Utility
Just the job
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now