We are running Confluence 6.15.2
We are now in the process up upgrading our MS sql server from 2012 to 2017.
What compatability level should we set the confluence database to when upgrading?
Currently it is set to level 100.
Thank you for contacting us about this. You will want to be on level 110 or higher, per the following:
I would recommend comparing the Supported Platforms page to this. SQL 2012 is the lowest supported version, which applies to 110.
Let me know if you have any trouble with this.
Thank you for the reply. However I am still not sure what compatability level you recomment for Confluence. Can we safely set compatability level to 140 (sql 2017) without any issues with confluence?
Or could we run into performance issues as mentioned in the first link you provided regarding the cardinal estimator when setting compatability level higher than 110?
As I recommended, you will want to be on level 110 or higher. This should not cause any performance issues. Since 140 is SQL 2017, this one would also be fine to use.
I hope that's clear but do let me know if you have any further concerns about this.
Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events