Once you upgrade ArcGIS Desktop or ArcGIS Pro on the instances in your ArcGIS Enterprise on Amazon Web Services (AWS) deployment, you can upgrade your enterprise geodatabases in Microsoft 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 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 Server web services 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.
- Log in as the Windows administrator to one of the Amazon Elastic Compute Cloud (EC2) instances in your ArcGIS Server site in AWS.
- Start ArcGIS Pro or ArcCatalog on that instance and connect to your enterprise geodatabase using operating system authentication.
- Run the Upgrade Geodatabase tool. 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 SQL Server, repeat steps 6 and 7 to upgrade them.
- Restart your ArcGIS Server web 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 tool. 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.