Post reply

comaptibility levels

  • March 10, 2011 at 6:50 am

    #233100

    We're on SQL 2005 now where 95% of our databases are set for SQL 2000 compatibility level 80. New databases get level 90.

    Will SQL 2000 compatibility level be available in the future or should we start working on getting them to 2008 after we upgrade? The applications (some 65 web apps) that access the database are based on WebSphere java, .net and asps. They are all custom designed.

  • March 10, 2011 at 8:29 am

    #1297128

    Run the SQL upgrade analyser and findout if any depriciated queries are used in ur 2000 database. If not change the cmpt level .

    If there was any,change the code .

  • March 10, 2011 at 8:36 am

    #1297133

    you'll need to take that into consideration when you upgrade; If you have a separate development server, I'd start testing with higher compatibility right away just to start tracking if anything breaks;

    with versions of SQL2008/2008R2, the available compatibility levels are 80 / 90 /100:

    http://msdn.microsoft.com/en-us/library/bb510680.aspx

    ALTER DATABASE database_name

    SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 }

    with the upcoming Denali version, 80 is removed.

    http://msdn.microsoft.com/en-us/library/bb510680%28v=sql.110%29.aspx

    ALTER DATABASE database_name

    SET COMPATIBILITY_LEVEL = { 90 | 100 | 110}

    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!

  • March 10, 2011 at 8:55 am

    #1297153

    Yes we do have a dev database server and will be getting one for SQL 2008. We will be testing there.

    I did run the upgrade advisor and it found several problems that will need to be fixed.

    Thanks for the information about Denali.

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

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