topic Re: Does ESRI database support SQL Server 2017 in Geodatabase Questions

Does ESRI database support SQL Server 2017

ShuhongYan — Thu, 01 Feb 2018 20:18:39 GMT

Our company plans to upgrade SQL Server from 2016 to 2017. Does SQL server 2017 support ESRI database? We are using ArcGIS Desktop 10.5+

Thanks

Re: Does ESRI database support SQL Server 2017

DanPatterson_Retired — Thu, 01 Feb 2018 20:35:35 GMT

From a quick link in the ArcGIS Pro help

http://pro.arcgis.com/en/pro-app/help/data/databases/database-requirements-sqlserver.htm

Re: Does ESRI database support SQL Server 2017

Asrujit_SenGupta — Fri, 02 Feb 2018 09:27:16 GMT

SQL Server 2017 is supported starting from ArcGIS 10.6.

Microsoft SQL Server database requirements for ArcGIS 10.6—System Requirements | ArcGIS Desktop

ArcGIS 10.5.x doesn't support that: Microsoft SQL Server database requirements for ArcGIS 10.5.x—System Requirements | ArcGIS Desktop

Re: Does ESRI database support SQL Server 2017

SharonGin2 — Wed, 07 Feb 2018 07:35:36 GMT

Will setting the SQL Server compatibility level to 13 on an SQL Server 2017 make ArcGIS Desktop 10.5.1 able to connect to the DB? Link for details on SQL Server compatibility level: ALTER DATABASE Compatibility Level (Transact-SQL) | Microsoft Docs

Re: Does ESRI database support SQL Server 2017

Asrujit_SenGupta — Wed, 07 Feb 2018 08:06:34 GMT

ArcSDE / SQL Server compatibility level

Connection should not be a problem. However, I am not completely sure if that may lead to any inconsistent behavior at a later point.

Re: Does ESRI database support SQL Server 2017

SharonGin2 — Wed, 07 Feb 2018 09:00:44 GMT

I would actually need to connect and set up replication across to the SQL 2017 database where parent is an SQL 2012. And my Geodatabase version is still at 10.2.2. Not sure if there will be issues in terms of Geodatabase versions and SQL version as well. Would you have any advice on that?

Re: Does ESRI database support SQL Server 2017

Asrujit_SenGupta — Wed, 07 Feb 2018 09:25:40 GMT

I would check with Esri, if they have plans to certify ArcGIS 10.5.x with SQL Server 2017. That would take care of this compatibility issue. Looking at previous trends, I expect that to happen.

By any chance, do you have ArcGIS Desktop 10.6 accessible to you?

Re: Does ESRI database support SQL Server 2017

Asrujit_SenGupta — Thu, 01 Mar 2018 10:07:55 GMT

Sharon Gin‌ It seems Esri now supports SQL Server 2017 with ArcGIS 10.5.x So just in case this helps!

Microsoft SQL Server database requirements for ArcGIS 10.5.x—System Requirements | ArcGIS Desktop

Re: Does ESRI database support SQL Server 2017

Asrujit_SenGupta — Thu, 01 Mar 2018 10:11:17 GMT

Esri now supports SQL Server 2017 for ArcGIS 10.5.x:

Microsoft SQL Server database requirements for ArcGIS 10.5.x—System Requirements | ArcGIS Desktop