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