Recently upgraded from SQL Server 2008 to SQL Server 2012. The MS Report Server databases did not automatically upgrade compatibility level. Should I force the upgrade?

  • Database compatibility level is never automatically updated when you update the version of the database engine.
    – AMtwo
    Commented Apr 18, 2017 at 19:46
  • Actually I think that's not accurate - if necessary a DB will be upgraded to meet the lowest level compatibility in the database engine although that's not my question.
    – Ram
    Commented Apr 18, 2017 at 19:49

1 Answer 1


This is not a question we can decide for you. Please review this Microsoft document especially the section with heading Differences Between Lower Compatibility Levels and Levels 110 and 120. Go through each item and decide for yourself.

Once you test thoroughly with new compatibility level you will know if you have any reason to keep old compatibility level (for backward compatibility). I prefer to use new compatibility level as you can see newer versions of SQL Server only support up to 3 or 4(maximum) older versions. If you do not do it now at some point you will be upgraded anyway.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.