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