Continue SQL Server transactional replication with AWS DMS

  • tttcoding

    SSC-Addicted

    Points: 418

    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

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

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply