locked
Compatibility Level RRS feed

  • Question

  • Hi Friends,
    Can somebody please , help me to know that what should be the compatibility level when we upgrade MSSQL 2000 TO MSSQL 2005 with the MSSQL 2005 CD?
    Thanks,
    Nausin
    Friday, August 29, 2008 5:30 PM

Answers

  • Welcome to MSDN,

     

     

    The compatiblity level should be 8.0 to 9.0

     

    8.0 - MSSQL 2000

    9.0 - MSSQL 2005

    10 - MSSQL 2008

     

    You Mark it as 90 compatiblity, as you are migration to MSSQL 2005 version.

     

     

    BR
    Praveen Barath

     

     

     

    Mark as answer if it helps
    Friday, August 29, 2008 5:33 PM
  •  Nausin wrote:
    Hi Friends,
    Can somebody please , help me to know that what should be the compatibility level when we upgrade MSSQL 2000 TO MSSQL 2005 with the MSSQL 2005 CD?
    Thanks,
    Nausin

     

    When you upgrade, SQL Server will set the compatibility level to the version that you upgraded from. In your case, you're upgrading from 80 to 90 so upon successful upgrade, your database will be in 80 mode. When you know that your queries have no compatibility issues, you should change it to 90.

     

    BOL documents in detail the difference between the compatibility levels. Most have to do further adherence to standards and some queries will break in 90 mode. Upgrade Advisor will identify them if they're in stored procedures, trace files or batch files.

    Friday, August 29, 2008 6:21 PM

All replies

  • Welcome to MSDN,

     

     

    The compatiblity level should be 8.0 to 9.0

     

    8.0 - MSSQL 2000

    9.0 - MSSQL 2005

    10 - MSSQL 2008

     

    You Mark it as 90 compatiblity, as you are migration to MSSQL 2005 version.

     

     

    BR
    Praveen Barath

     

     

     

    Mark as answer if it helps
    Friday, August 29, 2008 5:33 PM
  • Hi Praveen,
    Thanks for the immediate reply.
    Nausin
    Friday, August 29, 2008 5:41 PM
  • You are welcome.

     

    Mark as answer if it helps

     

    Friday, August 29, 2008 5:47 PM
  •  Nausin wrote:
    Hi Friends,
    Can somebody please , help me to know that what should be the compatibility level when we upgrade MSSQL 2000 TO MSSQL 2005 with the MSSQL 2005 CD?
    Thanks,
    Nausin

     

    When you upgrade, SQL Server will set the compatibility level to the version that you upgraded from. In your case, you're upgrading from 80 to 90 so upon successful upgrade, your database will be in 80 mode. When you know that your queries have no compatibility issues, you should change it to 90.

     

    BOL documents in detail the difference between the compatibility levels. Most have to do further adherence to standards and some queries will break in 90 mode. Upgrade Advisor will identify them if they're in stored procedures, trace files or batch files.

    Friday, August 29, 2008 6:21 PM
  • 2000 is 80, 2005 is 90, 2008 is 100

    regards¨

    Howard

    Thursday, November 27, 2008 2:01 PM