How can I restore my old data into the new design in SQL Server 2000

Tags:
SQL Database
SQL Server
SQL Server 2000
The SQL Server 2000 application I was using was badly designed. Now that there has been a rework of my database design, so many more tables and columns are being added. How can I restore my old data into the new design?
ASKED: March 17, 2008  2:34 PM
UPDATED: March 17, 2008  6:19 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is no way to directly restore data from one database design to another. Restoring data typically refers to taking a database backup and loading that backup into the SQL Server so that the database looks like it did at a prior point in time.

In order to load for data from the existing schema into your new schema you’ll need to use DTS or SSIS to move the data from each of the old tables into the new table, mapping each column into it’s new location. Some tables from the source schema will need to be split into two or more tables in the new schema (normalized) while some other tables may be combined from two or more tables in the old schema into a single table in the new schema (denormalized).

Whom ever designed the new schema should have a pretty good idea of what the differences between the two schemas are, and they should be able to do the bulk of the work setting up the DTS / SSIS package between the two schemas.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following