locked
Migration of SQL server compatibility level info RRS feed

  • Question

  • HI,

    When we are moving from sql 2005 to 2012, I am seeing few 80 compatibility level DBs. I know they dont work in 2012 (110 compatibility level). PLease let know what should be done in this case.

    Thanks in advance.

    Tuesday, June 16, 2015 6:41 AM

Answers

  • HI,

    When we are moving from sql 2005 to 2012, I am seeing few 80 compatibility level DBs. I know they dont work in 2012 (110 compatibility level). PLease let know what should be done in this case.

    Thanks in advance.

    This is one of the task you have to do after migration you have to change compatibility level of all the databases to 110.

    Please refer to change compatibility level

    if you found some features not working, just in case, you can change compatibility back to 90 or 80 but Microsoft suggests to keep compatibility level same as database version installed


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    • Marked as answer by VenBin Tuesday, June 16, 2015 7:14 AM
    Tuesday, June 16, 2015 6:48 AM