ArcSDE / SQL Server compatibility level

Question

I did not find anything in the ArcSDE documentation referring to SQL Server's compatibility level. Not too much mentioned on the forums either.

Can anyone come up with a scenario where the compatibility level of SQL Server should be set to a version earlier than the instance that is installed? Perhaps an old application that will not be updated?

Thanks for any help,

Paul Lohr

BillFox · Answer

See the "Supported Compatibility Level Values" column below.

Example: The SQL Server 2014 geodatabase can be set to 100 or 110 or 120 and ESRI is good to go.

Reference Microsoft SQL Server documentation:

ALTER DATABASE Compatibility Level (Transact-SQL)

Argumentshttps://msdn.microsoft.com/en-gb/library/bb510680.aspx#Anchor_1database_name
Is the name of the database to be modified.

COMPATIBILITY_LEVEL { 130 | 120 | 110 | 100 | 90 | 80 }
Is the version of SQL Server with which the database is to be made compatible. The following compatibility level values can be configured:

ProductDatabase Engine VersionCompatibility Level DesignationSupported Compatibility Level ValuesSQL Server 201613130130, 120, 110, 100SQL Database12120130, 120, 110, 100SQL Server 201412120120, 110, 100SQL Server 201211110110, 100, 90SQL Server 2008 R210.5105100, 90, 80SQL Server 200810100100, 90, 80SQL Server 200599090, 80SQL Server 200088080

-Bill

Thank you: asengupta-esristaff‌ SButala-esristaff‌

BillFox · Answer

Reference ESRI documentation v10.4:

Upgrade an enterprise geodatabase in SQL Server

Upgrade an enterprise geodatabase in SQL Server—Help | ArcGIS for Desktop

"Tip:

If you are unsure of the database compatibility level of your SQL Server database, check the database properties from Microsoft SQL Server Management Studio. If your database compatibility level is 80, you must update your database compatibility level. See SQL Server documentation for instructions."

But it does not indicate which level we must set it to for 10.4.1, 10.3.1. etc.

Asrujit SenGupta‌ SButala-esristaff

BillFox · Answer

Hi Paul,

Did you receive any further information about ESRI/SQL Server compatibility levels?

With 10.4.x not supporting SQL Server 2008 R2, has anyone seen ESRI documentation on SQL Server compatibility levels?

2016     130

2014     120

2012     110

2008 R2     105

2008     100

2005     90

2000     80

-Bill

Asrujit SenGupta‌ Sanket‌