Migrating a SQL Server Always On Database to Amazon Web Services - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Migrating a SQL Server Always On Database to Amazon Web Services

Microsoft SQL Server Always On is a high-availability feature for Microsoft SQL Server databases. With the synchronous-commit secondary replica, your application remains transparent to a failover. If the primary node in the Always On Availability Group (AAG) fails due to unforeseen circumstances or due to maintenance, your applications remain unaware of the failure, and automatically redirect to a functional node. You can use Amazon Database Migration Service (Amazon DMS) to migrate a SQL Server Always On database to all supported target engines. Amazon DMS has the flexibility to adapt to your Always On configuration, but it may be unclear how to set up the optimal Amazon DMS configuration.

Using this guide, you can learn how to configure Amazon DMS to migrate a SQL Server Always On database to Amazon. This guide also describes specific configuration and troubleshooting issues and best practices to resolve them.

The guide includes a customer use case and covers the issues that the customer encountered when configuring Amazon DMS, along with the solutions employed.

Topics