It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Compatability level when upgrading to Microsoft SQL 2017

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.

 

Regards

Tom

1 answer

1 accepted

0 votes
Answer accepted

Hello Tom,

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.

Regards,

Shannon

Dear Shannon

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?

 

Regards 

Tom

Hello Tom,

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.

Regards,

Shannon

OK thanks. We will go for 140

Like Shannon_Spaniol likes this

You're welcome, Tom!

Let us know if you have any trouble.

Take care,

Shannon

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

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...

294 views 9 7
Join discussion

Community Events

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

Events near you