How to consolidate databases from different SQL Server versions to one SQL Server 2005 database

Tags:
SQL Server database
SQL Server upgrades
We have 52 SQL Server databases on different SQL Server versions (6.5,7.0,2000). We need to consolidate all the databases into a single SQL Server 2005 database. The structure is almost the same for all the databases, i.e.,tables/datatype. The actual data is different in all the databases. Could you please provide advice or links to documents that would help consolidate these different SQL Server database versions to SQL Server 2005?

Answer Wiki

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

The first thing to do will be to get the SQL 6.5 databases into SQL 7 or higher. This is done by restoring the SQL 6.5 database to another server with SQL 6.5 on it, then installing SQL 2000 on the machine. SQL 2000 will include a SQL 6.5 upgrade system which will help you do the upgrade. I recommend doing this on a seperate machine in case something goes wrong.

After the databases are all in SQL 7 or above, you can take a full backup of them, and simply restore them to a SQL 2005 server.

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