Post reply

Upgrade from sql 2000 to sql 2005

  • September 9, 2010 at 11:29 pm

    #142686

    Hi All,

    Some of the application database server running on sql 2000. They plan to upgrade from 2000 to 2008.

    Client will not give time time. So we have to follow the below methods

    1) take a backup from sql 2000

    2) restore those backup to sql 2008

    3) Some of the DTS Packages migrated into SSIS package.

    My Question Is..

    a) Is it proper way for upgradation method

    b) suppose i follow this method.. Any problems comes in future

    c) If problem comes.. what is an alternate method?

    Could you pls suggest me

    Thanks & Regards

    Balaji.G

  • September 10, 2010 at 5:22 am

    #1219085

    Upgrading has been covered many times. You could search this site for "2000 2008 upgrade" and you will get a lot of information. Then maybe you can post more specific questions based on what you've learned.

  • September 10, 2010 at 8:04 am

    #1219178

    This is covered in the SQL Server 2008 Upgrade Technical Reference Guide. It's called a side-by-side upgrade.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

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

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