Home > IT Answers > SQL Server > SQL Server 2005 database conversion
Anto
5 pts.
 SQL Server 2005 database conversion
SQL database conversion, SQL Server 2000, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
HI, we plan to migrate SQL server 2005 from SQL server 2000. we have database with average size of 12GB. can any one please let me know how to convert our database from SQL2000 to SQL2005.Thanks in advance.

Software/Hardware used:
ASKED: March 1, 2011  11:34 AM
UPDATED: March 2, 2011  11:23 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by Denny Cherry

There isn't a specific conversion process that you have to do. Once you add the 2000 database to a 2005 server either by restore or attach, the server will go through an "upgrade" process to convert the db to 2005. This process is very brief compared to the upgrade from 6.5 to 7.0.

ANSWERED:  Mar 2, 2011  11:23 PM (GMT)  by Denny Cherry
 
Other Answers:

Install and use SQL Server Upgrade Advisor for that purpose. I recommend downloading the tool rather than using the version on the distribution media since u can then be sure that using the latest edition. Install the tool to a client machine rather than to a production database server. While Upgrade Advisor does not make any changes to your configuration. Start the Upgrade Advisor by going to Start > All Programs > SQL Server 2005 > SQL erver 2005 Upgrade. Rest is <a href=”http://searchsqlserver.techtarget.com/tutorial/Step-by-Step-Guide-Migrating-to-SQL-Server-2005-with-Copy-Database-Wizard”>HERE</a> and also see <a href=”http://support.microsoft.com/kb/224071″>HERE</a>

Last Wiki Answer Submitted:  March 1, 2011  12:10 pm  by  Subhendu Sen   22,035 pts.
Latest Answer Wiki Contributors:  Subhendu Sen   22,035 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _