We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work

Question

Hi

We need to configure the Pull subscription for transaction replication from On-Prem to Azure Managed Instance . How can we make it work.

We have come across documention which says its has limitations onwiht regards to publisher/subscriber and distributor .

Answer 1

Hi，Nitya V

There are some limitations when using Azure Managed Instance as a Pull subscriber. Please read the requirements to ensure the network configuration is correct. The following link provides a detailed introduction

https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql&source=recommendations

For configuring distributions on-premises, refer to the following:

https://learn.microsoft.com/en-us/sql/relational-databases/replication/create-a-push-subscription?view=sql-server-ver16

For configuring replication on a managed instance, refer to the following:

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-between-two-instances-configure-tutorial?view=azuresql

Best Regards,

Mikey Qiao

---

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

how about a Azure SQL Managed Instance

Azure SQL Managed Instance has less limitations and more roles.

Publisher and Distributor can be on prem server and still we can have pull on the subscriber.Please confirm.

The Publisher publishes changes made on some tables (articles) by sending the updates to the Distributor. The publisher can be an Azure SQL managed instance or a SQL Server instance.

The Subscriber receives changes made on the Publisher. A SQL Server instance and Azure SQL managed instance can both be push and pull subscribers，though a pull subscription isn't supported when the distributor is an Azure SQL managed instance and the subscriber isn't.

So you can configure Azure SQL Managed Instance as a pull subscriber.