Post reply

CONVERT MICROSOFT SQL SERVER 2000 Database to MICROSOFT SQL SERVER 2005 Database

  • December 18, 2008 at 11:37 am

    #199157

    Hi, This is nirmal.....

    I have a Microsoft SQL Server 2000 Database. I want to convert it to MICROSOFT SQL SERVER 2005 Database format.

    Kindly help me regarding this.

    Regards,

    Nirmal Gopalakrishnan

    CEO

    Nirmal Business Solutions Inc.

    India.

  • December 18, 2008 at 12:31 pm

    #914822

    You can simply restore the database backup from the 2000 machine to the 2005 machine. You can also detach the database files from the 2000 server and attach them (after copying or moving) on the 2005 server. After that you just have to change the compatibility level.

    That's the basics.

    The more extended version requires using the Upgrade Advisor and all kinds of other stuff. Check the documentation in the BooksOnline. It'll get you started.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply