locked
upgrade SQL 2000 to SQL 2008 RRS feed

  • Question

  • We are looking to upgrade our server runing SQL 2000 to a new server running SQL 2008.  What is the best way to migrate do this?  Is SQL 2008 only 64 bit? 
    Thursday, February 3, 2011 4:58 PM

Answers

  • Please refer following upgrade reference Technical guide.
    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

    you can refer following too .

    http://msdn.microsoft.com/en-us/library/cc936623(v=sql.100).aspx

    -------------
    Thanks,Suhas V

    • Proposed as answer by SQL JAADU Friday, February 4, 2011 7:47 AM
    • Marked as answer by Alex Feng (SQL) Monday, February 14, 2011 10:24 AM
    Thursday, February 3, 2011 5:10 PM
  • Best approach is to create a brand new setup running SQL 2008 if possible.

    Detach the database and attach on the new SQL box,  change database compatible (right click database/options) to SQL 2008 and run a full reindex on all tables (or use a previous backup for a test run).

    Script any  existing SQL agent jobs across (good time to clean up).

    Migrate DTS packages across to SQL 2008 using the migration tool, some changes may be required depending how complicated these are (again run this during a test phase first).

    Script across any  linked servers/users/etc.  between old/new server (relink user accounts to database).

    PS. Check any adhoc SQL code, some code that ran in SQL 2000 fine can grind to a halt under SQL 2008 (poorly written code).

     

     

     

    • Proposed as answer by Ron - Micatio Monday, February 7, 2011 11:14 AM
    • Marked as answer by Alex Feng (SQL) Monday, February 14, 2011 10:25 AM
    Monday, February 7, 2011 11:14 AM

All replies

  • Please refer following upgrade reference Technical guide.
    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

    you can refer following too .

    http://msdn.microsoft.com/en-us/library/cc936623(v=sql.100).aspx

    -------------
    Thanks,Suhas V

    • Proposed as answer by SQL JAADU Friday, February 4, 2011 7:47 AM
    • Marked as answer by Alex Feng (SQL) Monday, February 14, 2011 10:24 AM
    Thursday, February 3, 2011 5:10 PM
  •  SQL 2008 also available in 32 Bit also,
    -Subbrao Ardhalapudi
    Friday, February 4, 2011 7:48 AM
  • Best approach is to create a brand new setup running SQL 2008 if possible.

    Detach the database and attach on the new SQL box,  change database compatible (right click database/options) to SQL 2008 and run a full reindex on all tables (or use a previous backup for a test run).

    Script any  existing SQL agent jobs across (good time to clean up).

    Migrate DTS packages across to SQL 2008 using the migration tool, some changes may be required depending how complicated these are (again run this during a test phase first).

    Script across any  linked servers/users/etc.  between old/new server (relink user accounts to database).

    PS. Check any adhoc SQL code, some code that ran in SQL 2000 fine can grind to a halt under SQL 2008 (poorly written code).

     

     

     

    • Proposed as answer by Ron - Micatio Monday, February 7, 2011 11:14 AM
    • Marked as answer by Alex Feng (SQL) Monday, February 14, 2011 10:25 AM
    Monday, February 7, 2011 11:14 AM