Want to upgrade 2000-2005

  • Hi All

    as i am new to sql , please let me now weather i can upgrade sql200 to sql2005,

    If it is possiable please send some links that help me

    Regards

    sat_sql

  • SAT_SQL (7/6/2009)


    Hi All

    as i am new to sql , please let me now weather i can upgrade sql200 to sql2005,

    If it is possiable please send some links that help me

    Regards

    sat_sql

    Yes, it is possible to upgrade from SQL Server 2000 to SQL Server 2005.

    Download and read SQL2005UpgradeTechRef.doc from microsoft site. It has all the information you need.

  • You should have 2000 SP3 or higher to perform an upgrade to sql 2005.

    Also the link to the document mentioned in the previous post is

    http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en%5B/url%5D



    Pradeep Singh

  • SAT_SQL (7/6/2009)


    Hi All

    as i am new to sql , please let me now weather i can upgrade sql200 to sql2005,

    If it is possiable please send some links that help me

    Regards

    sat_sql

    Yes, it is possible to upgrade from SQL Server 2000 to SQL Server 2005.

    Download and read SQL2005UpgradeTechRef.doc from microsoft site. It has all the information you need.

  • Along with technical details, most important step is through testing of your application flow and T-SQL code with upgraded database server in test environment.

    Regards

    DBDigger Microsoft Data Platform Consultancy.

  • You should hire a consultant. If you are not aware of whether it's possible to upgrade, you likely do not have enough knowledge to do this. Hire someone, learn from them, and then you can move forward.

  • Hi,

    You can use the Update Advisor while migrating from 2000 to 2005 platform. It will list the major issues which you are going to face during migration. Pay attention and resolve those issues and then go ahead with it.

    Note:

    The SQL Server 2005 Upgrade Advisor is a downloadable tool from Microsoft.

    Cheers, 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

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