SQL Server 2005 database conversion

5 pts.
Tags:
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.

Answer Wiki

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

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>

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
  • Hlx
    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.
    690 pointsBadges:
    report

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