Upgrade a geodatabase in SAP HANA—ArcGIS AllSource

Available with Standard or Advanced license.

The goal of upgrading an enterprise geodatabase is to update the geodatabase system tables, stored procedures, types, and functions to take advantage of new functionality and bug fixes. You may also need to upgrade the database if the version you use is no longer supported for the ArcGIS clients you use.

Install a new version of ArcGIS AllSource or ArcGIS Server or apply a service pack, patch, or hot fix to an existing installation and upgrade the geodatabase.

Note:

Even if you do not upgrade the geodatabase, the database version you use may no longer be supported with the current release of ArcGIS software. If the database version is no longer supported, you may need to upgrade the geodatabase. The longer you go between upgrades, the more involved the upgrade process becomes.

When you upgrade the geodatabase using ArcGIS AllSource 3.5, the upgraded geodatabase version is 11.5.0.x.

Complete the required steps listed below prior to upgrading, and then upgrade the geodatabase using the Upgrade Geodatabase geoprocessing tool or a Python script.

Before you upgrade

Plan ahead before you upgrade any enterprise system, including a geodatabase. Test the new version on a development or test server to ensure that it works with all your client applications.

When you determine that the new system works the way you expect, schedule the upgrade; be sure the necessary staff are available to perform the upgrade and that they have the permissions necessary to complete their assigned tasks.

There is no formal mechanism to downgrade a geodatabase to a previous version. If, after upgrading to a newer version, you need to downgrade the geodatabase, you must restore the old database from a backup file.

The following is a checklist of steps to complete before you upgrade the geodatabase:

Read the ArcGIS requirements for SAP HANA to confirm that Esri supports the SAP HANA and ArcGIS version combination you want to use.
You can upgrade directly from a 10.8.x or later geodatabase if the SAP HANA database release is supported for the ArcGIS version to which you upgrade. If the database release is not supported for the geodatabase version you're upgrading to, you must also upgrade the database.
Read Client and geodatabase compatibility to understand the implications of using mixed ArcGIS client releases and to determine if specific dataset types must be upgraded separately.
Confirm that the geodatabase can be upgraded. To do this, install the ArcGIS AllSource or ArcGIS Server version to which you want to move onto one machine.
- To confirm from ArcGIS AllSource, connect to the geodatabase in the Catalog pane and open Database Properties. A message appears under Upgrade Status indicating whether an upgrade is possible.
- To confirm from ArcGIS Server, use the ArcPy Describe function to determine whether you can upgrade the geodatabase. The following is an example of creating a connection to the geodatabase and checking whether the geodatabase can be upgraded:
```
# Open Python.
cd /arcgis/server/tools
./python

# Import ArcPy.
import arcpy

# Create a connection to the geodatabase. You must connect as the sde user.
arcpy.CreateDatabaseConnection_management("/usr/tmp/",
                                          "egdb_connection.sde",
                                          "SAP HANA",
                                          "mydatabase",
                                          "DATABASE_AUTH",
                                          "sde",
                                          "mysdepassword",
                                          "SAVE_USERNAME")

# Check the geodatabase release.
isCurrent = arcpy.Describe('/usr/tmp/egdb_connection.sde').currentRelease

print(isCurrent)
```
  If False is returned, you can upgrade the geodatabase. Proceed with the remaining steps. If True is returned, you do not need to upgrade. Do not proceed with subsequent steps.
Confirm that the sde user has the appropriate privileges in the database.
Create a backup of the database.
Remove any custom functionality you added to the geodatabase system tables outside ArcGIS.
The upgrade procedure cannot accommodate customizations you make to the system tables. If such customizations prevent the alteration of a system table's schema, the upgrade will fail.
Confirm there are no other connections to the geodatabase you are upgrading.
See Manage connections to a geodatabase in SAP HANA.

You can now upgrade the geodatabase.

Upgrade the geodatabase

You can use the Upgrade Geodatabase tool in ArcGIS AllSource or a Python script run on an ArcGIS AllSource or ArcGIS Server machine to upgrade your geodatabase.

Note:

If the geodatabase contains branch versioned data, additional postupgrade steps may be required. See How Upgrade Geodatabase works for instructions.

Use the Upgrade Geodatabase tool

Open the Upgrade Geodatabase geoprocessing tool from one of the following:

The Geodatabase Administration toolset in the Data Management toolbox
The Run Upgrade button on the General tab of the Database Properties dialog box in ArcGIS AllSource

If you open the tool from Database Properties, the Input geodatabase text box is prepopulated with the geodatabase connection information.

Esri recommends that you leave the Pre-requisites check and Upgrade geodatabase options checked. That way, the tool confirms that the prerequisites to upgrade have been met before continuing with the geodatabase upgrade.

You must connect to the geodatabase as the sde user to run the prerequisite check and upgrade the geodatabase.

The prerequisite check detects other active connections to the geodatabase, determines whether you connected as the sde user, and confirms that the sde user has privileges to upgrade the geodatabase. If any prerequisites are not met, the tool terminates. You must correct any problems before you run the upgrade procedure again.

The results of this check are reported on the geoprocessing tool dialog box. If the check fails, results are also written to the GDBUpgrade.log file in the c:\Users\<user name>\AppData\Local\ESRI\<ArcGIS product> folder.

If all checks pass, the tool proceeds with the upgrade. The status for the prerequisites check and the upgrade are shown on the geoprocessing tool progress dialog box. If the upgrade fails, information is written to the GDBUpgrade.log file. Additional information is written to the sde_setup.log file in your user TEMP directory. If your user does not have a temp directory configured, the system TEMP directory is used.

Run a script

To upgrade the geodatabase using a Python script, copy one of the following example scripts, paste it into a text editor, alter it to use information specific to your site, save and close the file, and run it.

Tip:

For information about running Python from an ArcGIS Server machine, see ArcGIS Server and ArcPy.

The examples assume that you have an existing database connection file (.sde) that connects as the sde user. If you do not have a connection file, create one before upgrading.

# Name: upgradesdegdb_example.py
# Description: Connect from a Windows computer 
# with an existing database connection file 
# and upgrade an enterprise geodatabase.

# Import arcpy module
import arcpy
 
# Local variables:
Output_Workspace = "C:\\ArcGIS\connection_files\<Connection file>"
Default_gdb = "C:\\ArcGIS\connection_files\<Connection file>"

# Process: Upgrade Geodatabase
arcpy.UpgradeGDB_management(Default_gdb, "PREREQUISITE_CHECK", "UPGRADE")

# Name: upgradesdegdb_example.py
# Description: Connect from a Linux computer 
# with an existing database connection file 
# and upgrade an enterprise geodatabase.

# Import arcpy module
import arcpy
 
# Local variables:
Output_Workspace = "<user>/connections/<Connection_file>"
Default_gdb = "<user>/connections/<Connection_file>"

# Process: Upgrade Geodatabase
arcpy.UpgradeGDB_management(Default_gdb, "PREREQUISITE_CHECK", "UPGRADE")

Feedback on this topic?