0

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?

bumped to the homepage by Community yesterday

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

  • Database compatibility level is never automatically updated when you update the version of the database engine. – AMtwo Apr 18 '17 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 Apr 18 '17 at 19:49
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, privacy policy and cookie policy

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