Once you upgrade ArcGIS Desktop on the instances in your ArcGIS Enterprise on Amazon Web Services deployment, you can upgrade your enterprise geodatabases in SQL Server. The steps to upgrade the geodatabase vary slightly depending on whether your geodatabase runs in a SQL Server database or Amazon Relational Database Service (RDS) for SQL Server.
Upgrade an enterprise geodatabase in SQL Server
Follow these steps to upgrade an enterprise geodatabase in a SQL Server or SQL Server Express 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.
- 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:
- 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 Server web services that access data in your geodatabase before you upgrade.
- Sign in to the AWS Management Console and create a snapshot of the RDS for SQL Server instance.
See instructions in the AWS documentation for creating a snapshot.
- Connect to the RDS for SQL Server instance from SQL Server Management Studio and add the sde user to the db_owner role in the database.
- On one of your ArcGIS Server machines in AWS, start ArcGIS Pro or ArcCatalog and connect to your enterprise geodatabase in Amazon RDS for SQL Server. You must connect as the sde user.
- Run the Upgrade Geodatabase. See Upgrade an enterprise geodatabase in SQL Server in the ArcGIS Pro or ArcMap help for more information.
- If you have other enterprise geodatabases in Amazon RDS for SQL Server, repeat steps 4 and 5 to upgrade them.
- Restart your ArcGIS Server web services.
- If you want to, you can remove the sde user from the db_owner database role in each database.