Transactional Replication from Read replica

• cooldude001

  Mr or Mrs. 500

  Points: 534

  More actions

  March 27, 2025 at 11:28 am

  #4568416

  If I have Read replica (in Azure SQL MI), can it be used as a Publisher in transactional replication setup.

  I understand that Replication creates objects some objects in Publisher db, can we use listener name with applicationintent setting anywhere for it use Secondary instead of Primary.

  AWS DMS works similar to how transactional replication does (CDC and log reader agent). They have this option of using Read replica instead of Primary.

  AWS DMS for Replication

  Appreciate any help, thankyou

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  March 28, 2025 at 12:10 pm

  #4569162

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

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