You can access geodatabases using ArcGIS client software including the following:
- ArcGIS Pro (supports connecting to file, mobile, and enterprise geodatabases)
- ArcGIS Server services (support connecting to file, workgroup, and enterprise geodatabases)
Compatible 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.
This is especially true when you use a mix of client versions at your site. A newer client can create newer dataset types in the geodatabase that older clients cannot access. For enterprise geodatabases, waiting too long between geodatabase upgrades may mean you have to upgrade the underlying database more than once before you can upgrade the geodatabase.
The geodatabase version for an enterprise geodatabase is stored in a system table. It indicates what client version you used to create or upgrade the geodatabase. For example, if you create an enterprise geodatabase from ArcGIS Server 10.8.1, the geodatabase version is 10.8.1. If you subsequently upgrade the same geodatabase using ArcGIS Pro 2.9, the geodatabase version is 10.9.1.2.9. Be aware that this geodatabase version is primarily used by Esri Support to troubleshoot issues; it does not entirely reflect the functionality available to you, because a lot of geodatabase functionality is implemented in the clients that access the geodatabase and not in the geodatabase itself.
For enterprise geodatabases, the geodatabase version mostly only reflects what software version you used to create or upgrade the geodatabase. The version for file geodatabases has not changed since 10.1.
The following rules apply for compatibility:
- Use supported versions of ArcGIS for your clients and geodatabase.
- You must store your enterprise geodatabase in a database release that is supported for both the geodatabase and ArcGIS release you use. The database client you install on the ArcGIS client machine must also be supported for your ArcGIS release. See the following pages for more information about supported database and database client releases. Use the Other versions drop-down list to see information for older software releases and other operating systems.
- ArcGIS Pro 2.2 and earlier and ArcGIS 10.6.1 and earlier clients cannot connect to 11.x and later geodatabases in SQL Server.
- ArcGIS clients also include the API for that client. Therefore, the same mixed release rules apply when accessing the geodatabase using API.
- When you use clients that connect to an ArcGIS Server service, such as ArcGIS Field Maps or ArcGIS Survey123, ArcGIS Server is actually the client to the geodatabase. For these cases, make sure your ArcGIS Server and geodatabase versions are compatible.
- Older ArcGIS clients can open, query, edit, and save data in
newer release geodatabases, but they cannot open datasets that participate in newer functionality. You will encounter the following error messages when
you try to access a newer type of dataset from an older ArcGIS client:
The version of the Geodatabase client is incompatible with the dataset and cannot open it.
Failed to add data, unsupported data type.
- To connect from a newer ArcGIS client to an older release enterprise geodatabase, apply the latest patch to the geodatabase for its release if one exists.
- If you use geodatabase replication, the child replica geodatabase must be the same geodatabase release as or a later release than the parent replica geodatabase.
- If you upgrade your geodatabase and use the Upgrade Dataset geoprocessing tool to upgrade specific datasets, you may not be able to open the dataset from ArcMap or ArcGIS Pro 2.9 or earlier.
- The following datasets created or upgraded using ArcGIS Pro 3.0 or ArcGIS Server 11.0 and later cannot be used in ArcGIS Pro 2.9 and earlier:
- Annotation datasets
- Dimensions
- Utility networks
- Trace networks
When do you need to upgrade a geodatabase?
It's best to keep your geodatabase and client versions as close as possible. Sometimes, you have to upgrade the geodatabase. You must upgrade your geodatabase if either of the following is true:
- The client release you are using cannot connect to the geodatabase release you want to use. For enterprise geodatabases, the client release you're using may not be able to connect to the database management system version you're using, and you need to upgrade both the database and the geodatabase to connect from a newer client.
- You want to take advantage of functionality that is available only if you use a newer release of the geodatabase. Check each version of What's new in ArcGIS Pro for information on new functionality and dataset types in the geodatabase. Be aware that when you create new dataset types or upgrade a dataset, such as a parcel fabric or a network dataset, older clients will no longer be able to access the dataset.
For more information about geodatabase upgrades, see the upgrade topics for the type of geodatabase you are using:
File geodatabases | Upgrade a file geodatabase |
Geodatabases in Db2 on Linux or Microsoft Windows | Upgrade a geodatabase in Db2 |
Geodatabases in Oracle | Upgrade a geodatabase in Oracle |
Geodatabases in PostgreSQL | Upgrade a geodatabase in PostgreSQL |
Geodatabases in SAP HANA | Upgrade a geodatabase in SAP HANA |
Enterprise geodatabases in SQL Server | Upgrade a geodatabase in SQL Server |
Geodatabase versions
Sometimes, documentation states that you need a specific version of the geodatabase to use specific functionality. Often, that version is listed as the 10.x or 11.x version of the geodatabase. As stated previously, when you create or upgrade an enterprise geodatabase in ArcGIS Pro, the geodatabase version number is a combination of the 10.x or 11.x and ArcGIS Pro release numbers. When you create or upgrade a geodatabase from a 10.x or 11.x client, the geodatabase version is the 10.x release number only.
Use the information in the following table to determine the ArcGIS Pro release used to create or upgrade a geodatabase based on the version stored in the geodatabase's version system table:
Geodatabase version | ArcGIS Pro release | Equivalent 10.x or 11.x release |
---|---|---|
10.6.1.2.2 | 2.2 | 10.6.1 |
10.7.0.2.3 | 2.3 | 10.7 |
10.7.1.2.4 | 2.4 | 10.7.1 |
10.8.0.2.5 | 2.5 | 10.8 |
10.8.1.2.6 | 2.6 | 10.8.1 |
10.9.0.2.7 | 2.7 | 10.9 |
10.9.0.2.8 | 2.8 | 10.9 |
10.9.1.2.9 | 2.9 | 10.9.1 and 10.8.2 |
11.0.0.3.0 | 3.0 | 11.0 |