If you applied software updates to the ArcGIS clients on an ArcGIS Enterprise on Amazon Web Services, you can upgrade your enterprise geodatabases in SQL Server. You can do this from the Database Properties dialog box in ArcGIS Desktop. The steps vary slightly depending on whether your geodatabase runs in a SQL Server database or Amazon Relational Database Service (RDS) for SQL Server.
Upgrade a geodatabase in SQL Server
Follow these steps to upgrade an enterprise geodatabase in a SQL Server instance on AWS:
- 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.
Tip:
The databases created by the Esri sample CloudFormation templates and Cloud Builder are named egdb and geodata.
- On one of your ArcGIS Server machines in AWS, start ArcCatalog or ArcMap and open the Catalog window.
- Connect to one of the enterprise geodatabases in SQL Server.
- 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 11 to upgrade your other enterprise geodatabases.
- Restart your services.
Upgrade a geodatabase in Amazon RDS for SQL Server
Follow these steps to upgrade a geodatabase in Amazon RDS for SQL Server:
- 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.
Tip:
The databases created by the Esri sample CloudFormation templates and Cloud Builder are named egdb and geodata.
- While still in SQL Server Management Studio, add the sde user to the db_owner role in each database that contains a geodatabase.
- On one of your ArcGIS Server machines in AWS, start ArcCatalog or ArcMap and open the Catalog window.
- Connect to one of the enterprise geodatabases in Amazon RDS for SQL Server. You must connect as the sde user.
- 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 6 through 12 to upgrade your other enterprise geodatabases.
- Restart your services.
- If you want to, you can remove the sde user from the db_owner database role in each database.