When you deploy ArcGIS Enterprise or stand-alone ArcGIS Server (Enterprise edition) sites on Amazon Web Services (AWS), you can create and register a geodatabase in Amazon Relational Database Service (RDS) for SQL Server with your federated or stand-alone ArcGIS Server sites.
Once the geodatabase is created and registered with the site, you need to move data into the geodatabase. When you publish services from this data or later delete these services, the data remains in the geodatabase.
Use ArcGIS tools to create a geodatabase
The ArcGIS Enterprise on Amazon Web Services deployment tools provide options to include a geodatabase in Amazon RDS for SQL Server. The geodatabase created by the deployment tools is named egdb. ArcGIS Enterprise Cloud Builder Command Line Interface for Amazon Web Services and ArcGIS Enterprise Cloud Builder for Amazon Web Services register the geodatabase as the ArcGIS Server site's managed database. When you use Esri AWS CloudFormation templates, you have the option to add the geodatabase as a registered database or managed database.
When you use Amazon Relational Database Service (RDS) for SQL Server with ArcGIS software, connect using database-authenticated logins. Esri tools that create an ArcGIS GIS Server site create two SQL Server logins and database users when you choose to include an Amazon Relational Database Service (RDS) for SQL Server instance with your deployment. The password for these logins is the same as the password you specified for the ArcGIS Server primary site administrator.
- EsriRDSAdmin: The EsriRDSAdmin user is the RDS master user, who creates the databases and sde user.
- sde: The sde user owns the geodatabase system objects and is considered the geodatabase administrator.
Amazon Relational Database Service (RDS) for SQL Server instances created with the ArcGIS Enterprise on Amazon Web Services deployment tools do not have mirroring enabled by default. If you require this functionality, you must manually enable it. See the Amazon Relational Database Service User Guide for more information.
Use AWS Management Console
If you create your site using the AWS Management Console and want to use Amazon Relational Database Service (RDS) for SQL Server for data storage, you need to create the database, logins, schemas, and enterprise geodatabase yourself, grant the users the privileges they require, and register the geodatabase with your ArcGIS Server site. See Create a geodatabase on Amazon Relational Database Service (RDS) for SQL Server for more information.
All geodatabases in Amazon RDS for SQL Server must be sde-schema geodatabases.