Continue SQL Server transactional replication with AWS DMS

• tttcoding

  SSC-Addicted

  Points: 418

  July 21, 2019 at 8:43 pm

  #3664888

  Hello,

  I have a task for which I wasn't able to find much information on the net, so please if anyone can share some experience.

  I have a production database hosted on SQL Server 2016 instance which we need to move to AWS. For this database we have enabled transactional replication with a separate distributor server. When migrated to AWS we have a task to continue the replication with the AWS Database Migration Service.

  I did read the whole documentation of this tool and I have already configured a synchronous transactional replication with it for a couple of times, but all these tasks were for a new replication, from start. Now I have to stop the transactional replication for the databases we are moving and continue it with AWS DMS when the client will be migrated to AWS.

  Can you please share some known approaches to such a task or maybe a proven best practice?

  Thanks in advance,

  Tomi

• Site Owners

  SSC Guru

  Points: 80385

  July 22, 2019 at 9:10 pm

  #3665216

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.