Upgrading an ArcSDE geodatabase in SQL Server

Beginning with ArcGIS 10, geodatabases are upgraded using the Upgrade Geodatabase geoprocessing tool or Python script. Therefore, you must have the current version of ArcGIS Desktop, ArcGIS Engine, or ArcGIS Server installed on the computer from which you will run the upgrade because these applications can run the geoprocessing tool or Python script.

Note:

If you are upgrading a geodatabase in SQL Server that uses the multiple spatial database model, be sure to run the upgrade on the sde database.

Be sure you have read and performed the steps in Preparing to upgrade a geodatabase in SQL Server before you upgrade.

This topic explains how to upgrade an ArcSDE geodatabase by launching the Upgrade Geodatabase geoprocessing tool from the Upgrade Geodatabase button on the Geodatabase Properties dialog box. You could also search for the tool and run it, or you could run a Python script.

Steps:

1. Start ArcCatalog, or start ArcMap, ArcGlobe, or ArcScene and open the Catalog window.
2. Expand the Database Connections node. Connect to the geodatabase you want to upgrade.

   You must use a direct connection to the geodatabase and connect as the ArcSDE administrator.

   Note:

   If the connection does not already exist, add a new connection. See Making a direct connection from ArcGIS Desktop to a geodatabase in SQL Server for instructions.

3. Right-click the geodatabase and click Properties.
4. 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 ArcSDE geodatabase, your DBMS is not at a supported upgradable release, you are using an ArcSDE service connection rather than a direct connection to the geodatabase, or you are connecting from an ArcGIS Desktop client running under an ArcView license.

5. Click the Upgrade Geodatabase button.

   The Upgrade Geodatabase geoprocessing tool opens. The Input geodatabase text box is prepopulated with the geodatabase connection information when launched using the Upgrade Geodatabase button.

Note:

You cannot run the Upgrade Geodatabase tool if any other geoprocessing tools are currently running as background processes on the client machine.

6. Esri recommends that you leave both the Pre-requisites check and Upgrade geodatabase options checked on the Upgrade Geodatabase geoprocessing tool dialog box. That way, the tool checks to see if the prerequisites to upgrade have been met before continuing with the geodatabase upgrade.

   The prerequisite check detects other active connections to the geodatabase, determines whether the connecting user has sufficient privileges to upgrade the geodatabase, ensures that the database can support XML columns, ensures that, if you are connecting to a multiple-spatial database model geodatabase that you are connected to the sde geodatabase, and makes sure all datasets can be opened. 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 in the geoprocessing tool dialog box and the GDBUpgrade<#>.log, which can be found in the system TEMP directory.

7. Click OK to start the checks and upgrade.
8. If all checks are passed, the tool proceeds with the upgrade. The status for the prerequisites check and the upgrade are shown on the geoprocessing tool progress dialog box as well as the GDBUpgrade<#>.log. Additional information can be found in the sdesetup log, which is also created in the system TEMP directory.
9. When the tool successfully completes, click Close to close the geoprocessing tool progress dialog box.

Your geodatabase is upgraded to the latest release.

To upgrade network datasets or cadastral or parcel fabrics in the geodatabase, use the Upgrade Network or Upgrade Parcel Fabric geoprocessing tools or Python scripts.

Note:

Upgrades of network datasets and cadastral or parcel fabrics are optional. However, if you do not upgrade them, you do not have access to the latest functionality in network datasets and parcel fabrics.