Setup replication for a always on database that will be used as a source for aws dms task

Question

Hi, We need to setup replication for a always on database that will be used as a source for aws dms task. Our availability group has two replica.Got replication installed on both the replica. Setup publication for the required DB on primary instance. Have chosen the primary server to act as its own distributor.Required tables were added as articles & snapshot was generated successfully. Noticed the publication hot automatically created on secondary replica too. Enabled distribution on secondary replica by choosing it as its own distributor. But since we do not have the snapshot or log reader agent created on secondary replica, I am concerned if dms task would be able to sync the data in case of a failover. I see a replication job 'monitor and sync replication agent jobs' when runs SP 'sys.sp_msrepl_monior_job_at_failover@all=1' created on both servers. Any idea what this job does?. If you have worked on a similar setup where you configured your sql always on db as a source for aws dms tak, can you help with the setup.

Answer 1

Hi @SSG

configured your sql always on db as a source for aws dms tak

Not worked with aws dms.

If you're interested in configuring Always On, please refer to this doc: Tutorial: Manually configure an availability group - SQL Server on Azure VMs

Also, here are some docs that might help:

SQL Server Always On Availability Groups.

Using a Microsoft SQL Server database as a source for AWS DMS.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.