Upgrade enterprise geodatabases in SQL Server in ArcGIS Server for Amazon Web Services
If you applied software updates to the ArcGIS clients on an ArcGIS Server for Amazon Web Services instance, you can upgrade your enterprise geodatabases in SQL Server. You can do this from the Database Properties dialog box in ArcGIS for Desktop as described in the following steps:
- Log in to your ArcGIS Server instance using the administrator login.
- There cannot be any users other than the administrator connected to the geodatabase when you upgrade. This includes service connections. You must stop any ArcGIS service connections that access data in your geodatabase before you upgrade.
- Start Microsoft SQL Server Management Studio and log in with Windows authentication.
- Create a full backup of each of the databases that contain an enterprise geodatabase.
If you only use the geodatabases provided with your ArcGIS Server for Amazon Web Services instance, the databases are egdb and geodata.
- On your ArcGIS Server instance, start ArcCatalog or ArcMap and open the Catalog window.
- Connect to one of the enterprise geodatabases.
- Right-click the geodatabase connection under Database Connections in the Catalog tree.
- Click the General tab.
- Click Upgrade Geodatabase.
The Upgrade Geodatabase geoprocessing tool opens.
- Leave both the Pre-requisites check and Upgrade geodatabase options checked and click OK to upgrade the geodatabase.
- When the tool completes successfully, click Close to close the geoprocessing tool progress dialog box.
If the tool does not complete successfully, information is written to the GDBUpgrade.log found in C:\Users\<user name>\AppData\Local\ESRI\Desktop<#>.
- Repeat steps 5 through 10 to upgrade your other enterprise geodatabases.
- Restart your services.