Share via

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

Nitya V 40 Reputation points
2024-05-15T17:41:11.7933333+00:00

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 .

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,918 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
    2024-05-16T05:35:53.2466667+00:00

    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.

  2. MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
    2024-05-17T05:54:03.63+00:00

    how about a Azure SQL Managed Instance

    Azure SQL Managed Instance has less limitations and more roles.

    User's image

    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.

    User's image

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