nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Compatability level when upgrading to Microsoft SQL 2017

Tom Birch Hansen

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

Accepted answers

Shannon S

Hello Tom,

Thank you for contacting us about this. You will want to be on level 110 or higher, per the following:

The Importance of Database Compatibility Level in SQL Server

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

All comments

Shannon S

Hello Tom,

Thank you for contacting us about this. You will want to be on level 110 or higher, per the following:

The Importance of Database Compatibility Level in SQL Server

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

Tom Birch Hansen

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

Shannon S

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

Tom Birch Hansen

OK thanks. We will go for 140

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

sql

upgrade