Available with Standard or Advanced license.
Upgrading a geodatabase updates the geodatabase system tables and stored procedures to take advantage of functionality available in the latest release of ArcGIS. Upgrading a geodatabase is optional in most cases, but if you do not upgrade, you will not have access to newer functionality or fixes.
The files that allow you to use geodatabases on database servers (SQL Server Express) are part of ArcGIS clients. Install a newer version of ArcMap and upgrade each geodatabase on the database server.
Follow these steps to upgrade a workgroup geodatabase from ArcMap:
- Start ArcMap and open the Catalog window, or start ArcCatalog.
- Expand the Database Servers node in the Catalog tree.
- Connect to the database server that contains the geodatabase you want to upgrade.
- Make a backup of the geodatabase before upgrading it.
- Right-click the geodatabase to upgrade and click Properties.
- Click the General tab.
If an upgrade is needed, the Upgrade Geodatabase button is active.
If the Upgrade Geodatabase button is not active, it could be because the connecting client is at the same release as the geodatabase, your DBMS is not at a supported upgradable release, or you are connecting from an ArcGIS Desktop Basic client.
- Click Upgrade Geodatabase.
The Upgrade Geodatabase geoprocessing tool opens. The Input geodatabase text box is prepopulated with the geodatabase connection information when the tool is launched using the Upgrade Geodatabase button.
- Leave both the Perform Pre-requisite check and Upgrade geodatabase options checked and click OK.
A dialog box appears showing the progress of the prerequisite check and upgrade. If there are any errors in the process, they appear in this dialog box.
The prerequisite check detects whether full-text search is enabled on the SQL Server Express instance, no other users are connected to the geodatabase, and all datasets can be opened. If the geodatabase meets these requirements, the tool proceeds with the upgrade. If the geodatabase does not meet the requirements, the tool terminates, and you must correct the prerequisite problems before you run the Upgrade Geodatabase tool again.
The results of this check are reported on the geoprocessing tool dialog box and in the GDBUpgrade<n>.log, which can be found in a subfolder of the system %TEMP% directory.
- When the upgrade operation completes successfully, click Close to close the dialog box.
The geodatabase is now upgraded.
- Repeat steps 4 through 9 for each geodatabase on the database server you want to upgrade.
You can launch the Upgrade Geodatabase geoprocessing tool from the Search window, or script the upgrade using Python.
- If you want to continue working with the database server and its geodatabases, you must disconnect from it and reconnect to refresh the connection. To do this, right-click the database server, click Disconnect, then either double-click the database server or right-click it and click Connect to reconnect to it.
You cannot run the Upgrade Geodatabase tool if any other geoprocessing tools are currently running as background processes on the client machine.
If you have parcel fabrics or network datasets in your geodatabase that you want to upgrade, you must upgrade them separately. These upgrades are optional, but if you do not upgrade them, you will not have access to the latest network dataset or parcel fabric functionality.