Consolidating SQL Server databases

Tags:
SQL Server 2000
SQL Server 2005
SQL Server Database Consolidation
SQL Server databases
How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.
ASKED: December 9, 2008  9:09 PM
UPDATED: December 10, 2008  2:47 PM

Answer Wiki

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

Upgrade SQL Server with the Copy Database Wizard

This topic describes how to use the Copy Database Wizard to upgrade a SQL Server database to a later version.

When using the Copy Database Wizard to upgrade a database, adhere to the following requirements:

* Before upgrading, make sure that no applications or services are trying to access the database. Do not use read-only mode, as this will result in an error.
* You cannot rename the database during this operation.

Procedure
To upgrade a SQL Server 2000 database to a later version

1. Connect to any instance of SQL Server Database Engine using Object Explorer in SQL Server Management Studio.
2. Expand Databases, right-click a database, point to Tasks, and then click Copy Database.
3. Complete the steps in the wizard.

To ensure optimal performance of an upgraded database, run sp_updatestats (update statistics) against the upgraded database.

After you use the Copy Database Wizard to upgrade a SQL Server 2005 or SQL Server 2000 database to SQL Server 2008, the database becomes available immediately and is then automatically upgraded. If the database has full-text indexes, the upgrade process either imports, resets, or rebuilds them, depending on the setting of the Full-Text Upgrade Option server property. If the upgrade option is set to Import or Rebuild, the full-text indexes will be unavailable during the upgrade. Depending the amount of data being indexed, importing can take several hours, and rebuilding can take up to ten times longer. Note also that when the upgrade option is set to Import, if a full-text catalog is not available, the associated full-text indexes are rebuilt.
___________________________________________________________________________________
You can detach a SQL Server 2000 database from the SQL Server 2000 instance and attach it to the SQL Server 2005 instance. Then simply point the clients to the new server. Consolidating from SQL Server 2000 to SQL Server 2005 is basically the same as consolidation from SQL Server 2005 to SQL Server 2005.

Look at the last section of <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1332773,00.html”>this article</a>.

Discuss This Question:  

 
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