What happens to a DMS job when a SQL Server AG fails over?

Question

I have a customer who is planning a migration from on-prem SQL-Server to EC2 SQL Server using DMS.  They want to know what will happen in the event the SQL Server AG fails over (on-prem to on-prem failover in event of HW failure for example) while DMS is running to sync data to AWS.  Details on what will happen appreciated - customer DBA manager would like to know more than a "it'll be fine" type answer if possible.

Accepted Answer

If you specify the Domain Name Service (DNS) name or IP address that was configured for the Availability Group Listener. In the event of AG failover, the new secondary will becomes as source instance for DMS and replication continues.

To use AlwaysOn Availability Groups as a source in AWS DMS, do the following:

1.  Enable the Distribution option on all SQL Server instances in your Availability Replicas.

2.  In the AWS DMS console, open the SQL Server source database settings. For Server Name, specify the Domain Name Service (DNS) name or IP address that was configured for the Availability Group Listener.

It is indicated in our documentation below link:

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.AlwaysOn

What happens to a DMS job when a SQL Server AG fails over?

相关内容