Post reply

Steps to Update Sql server 2000 to 2005 & 2005 to 2008

  • September 17, 2010 at 4:39 am

    #224085

    Hello Everyone

    I have an urgent requriement to update my database to Sql Server 2005 and Sql Server 2008. So I am looking to have detailed notes for updating sql server 2000 to sql server 2005 and sql server 2005 to sql server 2008. Therefore I request you to mail me the steps to proceed.

    Thanks in Advance.

    V.Santosh Kumar.

  • September 17, 2010 at 6:35 am

    #1222923

    upgrading an installation form SQL 2000 to SQL 2008 is as simple as running the msi and clicking next 5 or 6 times;

    there is no reason to upgrade to an intermediate version(2005); just directly install 2008.

    MS has a document specifically about this procedure, which i found now that Google is back up and running again; it must have been down earlier, which is why you didn't find it, i guess:

    [DOC] SQL Server 2000 to 2008 Upgrade - Microsoft Corporation

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 17, 2010 at 9:16 am

    #1223099

    To update a database, attach (or restore) the files on the higher version server. If you are looking to upgrade your entire instance, then run the Upgrade Advisor, and then the setup program, as noted by Lowell.

  • September 17, 2010 at 9:24 am

    #1223109

    Lowell (9/17/2010)

    upgrading an installation form SQL 2000 to SQL 2008 is as simple as running the msi and clicking next 5 or 6 times;

    there is no reason to upgrade to an intermediate version(2005); just directly install 2008.

    MS has a document specifically about this procedure, which i found now that Google is back up and running again; it must have been down earlier, which is why you didn't find it, i guess:

    [DOC] SQL Server 2000 to 2008 Upgrade - Microsoft Corporation

    Are there potential risks that the application will stop working you change the compatibility level from 8 to 9 or 10?

  • September 18, 2010 at 4:10 am

    #1223451

    Hello Lowell

    Thank you very much for the document. No there are no issues which prevents from upgrading to level 8 r 9 r 10.

    Thanks once again.

    Thanks & Regards.

    V.Santosh Kumar.

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

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