Configuration of Pull Transaction replication from ON-Prem to Azure Managed Instance for reporting purpose

Question

I need to configure the Pull transaction replication from On-Prem to Azure Managed Instance where my Distributer will on Azure Managed instance. Please let me know will it work or i have to use to some other option.

Answer 1

Hi @Deepak Bhardwaj ,

If you want to configure transactional replication from the on-premises server to Azure SQL Managed Instance, it is only support push mode as below screenshot. And in this situation both the publisher and distributor need to be placed on the on-premises server. You can confirm this from the MS document that I offered in first reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Hi @Deepak Bhardwaj ,

No, it is not supported. Configuring transactional replication with Azure SQL Managed Instance there are some limitations that we need to take into consideration. One of them is that both the publisher and distributor need to be placed either on Managed Instance or on the on-premises server. The other requirements can be found here.

So you can put the distributor on the on-premises server. And this situation only support push mode. Refer to this document to get more information about configure replication on Azure SQL Managed Instance .

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 3

ok it Means that i have to use IaaS instance for Pull replication where as Azure Synapse can be used for the same for data replication,