Post reply

checking to see if I can change from 8.0 to 9.0 compatibility

  • June 10, 2010 at 12:37 pm

    #141447

    I have inherited a database in 8.0 compatibility and I'm trying to see if there is a way I can easily find out what needs to be changed to get it to the 9.0 compatibility level like I would have gotten had the advisor been run before the database was upgraded from sql 2000 to sql 2005

  • June 10, 2010 at 12:45 pm

    #1178855

    yes you can change compatibility mode without a problem;

    compatibility mode only tells SQL to filter the commands coming in against a set of version-specific-syntax; it does not change how the data is stored, or invalidate higher version objects or anything...just prevents some newer syntax commands.

    that's why you can change it dynamically...it doesn't affect teh data, just commands that might hit the data.

    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!

  • June 11, 2010 at 12:35 am

    #1179030

    You can change Compatibility Level in SQL Server 2005 by right clicking your database -> Properties -> Options -> Compatibility Level.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

  • June 11, 2010 at 6:46 am

    #1179128

    Why not download and run the advisor?

    If you've already changed to 90: back it up, change compatibility back to 80 and run it.

    _____________________________________________________________________
    - Nate

    @nate_hughes

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

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