topic Re: ArcGIS Server SDE Datastore connection forward compatibility in ArcGIS Enterprise Questions

ArcGIS Server SDE Datastore connection forward compatibility

MarekSambor — Sun, 26 Nov 2023 21:22:21 GMT

Hi,

I have ArcGIS Enterprise servers in versions 10.9.1 and 11.2.0 that are connected to the same SDE Oracle Geodatabase.

I'm planning to upgrade the SDE EGDB to version 11.2.

Is it necessary to upgrade all ArcGIS Server (Enterprise) nodes to version 11.2, or is it not obligatory? Will registered Datastore SDE connections still work when connecting from ArcGIS Server 10.9.1 to a Geodatabase in version 11.2?

Let's assume that Oracle clients will be upgraded to be compatible with Oracle 19c.

Thanks!

Re: ArcGIS Server SDE Datastore connection forward compatibility

Scott_Tansley — Sun, 26 Nov 2023 23:18:29 GMT

It's a bit more of a story than just geodatabase version to ArcGIS Server version. There's the whole driver, and database version thing to consider as well.

10.9.1 - https://enterprise.arcgis.com/en/system-requirements/10.9.1/windows/database-requirements-oracle.htm

11.2 - https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-oracle.htm

Fortunately for you, both support 19c! 🙂

You also need to consider support for drivers, which I don't think will be an issue here.

You also need to consider what versions of ArcGIS Pro you are using and their support to that database version and geodatabase version.

Geodatabase now offer a degree of forward/backward compatibility. It used to be that you kept them at the lowest common denominator. There also used to be a matrix saying exactly what GDB versions were supported by application version. Now the 'advice' is stay as close as you can.

Obviously, if you use a 11.2 GDB with 10.9.1 then 10.9.1 will not be able to use any new functionality in there.

You also need to consider if you're using advanced types, like Parcel Fabrics or Utility Models. In those situations, I believe there are strong rules about Pro versions being matched to Enterprise versions, being matched to EGDB version and possibly even database versions.

Quite a bit to consider, sorry if I've muddied the waters.

Re: ArcGIS Server SDE Datastore connection forward compatibility

MarceloMarques — Mon, 27 Nov 2023 01:47:54 GMT

Client and geodatabase compatibility—ArcGIS Server | Documentation for ArcGIS Enterprise

Geodatabase and ArcGIS releases

You do not have to keep your geodatabase and ArcGIS clients at the same release, but it is recommended that you do so. Geodatabases and client software are designed to work together, and if you let one get too many releases away from the other, you risk encountering problems or unexpected behavior. ( read more in the link above !!! )

ArcGIS 11.2 and ArcGIS Pro 3.2 requirements for Oracle—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

Re: ArcGIS Server SDE Datastore connection forward compatibility

MarceloMarques — Mon, 27 Nov 2023 16:31:18 GMT

community.esri.com

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

How to Move the Oracle Enterprise Geodatabase with the Oracle Data Pump Utility

Oracle eGDB SDE Repo Upgrade Using Oracle Restore Point | Download PDF Version