Post reply

Comparability mode

  • January 23, 2015 at 2:58 am

    #294644

    Hi,

    Have a data base used for third party software. Looking to upgrade to SQL 2012 and because the current version won't go to 2012 I was thinking about installing it and running it on 2008 comparability mode, applying the latest third party software which will upgrade the database to be compatible with 2012 and then changing it to run in 2012 mode.

    This seemed more sensible than installing 2008, doing the upgrade on that and then upgrading 2008 with 2012.

    Has anyone done anything like this or had issues with changing the compatibility mode?

    Cheers

  • January 23, 2015 at 7:37 am

    #1772625

    There are always some issues with upgrades. May or may not affect your 3rd party stuff but it sounds like you have a good plan.

    I'd do it on a test box, first, though.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 23, 2015 at 5:42 pm

    #1772858

    Changing the compatibility mode after your third party software upgrade is in place should be fine. As Jeff indicated, you definitely want to do this in a test environment first.

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

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