Continue SQL Server transactional replication with AWS DMS

• mTBCent

  SSChasing Mays

  Points: 652

  More actions

  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: 80330

  More actions

  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.