On-Premices SQL(Non Azure VM) as publisher and Azure SQL Managed Instance as Subscriber?

chetan Vishwakarma 146 Reputation points
2021-11-17T19:05:51.79+00:00

I have to setup a replication between on-premices to Azure SQL Managed Instance. Can anyone let me know whether it can be possible ?

Publisher : On-premices SQL server (No Azure VM)
Subscriber : Azure SQL Managed Instance.

It would be great if share the documentation on this.

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,561 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
368 questions
1 vote

Accepted answer
  1. Alberto Morillo 24,801 Reputation points Microsoft MVP
    2021-11-17T20:03:42.883+00:00

    It is one of the supported scenarios as stated on this documentation. However, the Distributor should be SQL Server on-premises instance also.

    No comments

1 additional answer

Sort by: Most helpful
  1. CathyJi-MSFT 20,666 Reputation points Microsoft Employee
    2021-11-18T00:45:15.347+00:00

    Hi @chetan Vishwakarma ,

    Yes, it is possible.

    Your scenario is like below screenshot.

    150260-screenshot-2021-11-18-081200.jpg

    Azure SQL Managed Instance can support being a Subscriber from the following versions of SQL Server:
    •SQL Server 2016 and later
    •SQL Server 2014 RTM CU10 (12.0.4427.24) or SP1 CU3 (12.0.2556.4)
    •SQL Server 2012 SP2 CU8 (11.0.5634.1) or SP3 (11.0.6020.0) or SP4 (11.0.7001.0)

    There are also some other requirements for this configuration, please refer to this MS document Transactional replication with Azure SQL Managed Instance to get more information.

    Please refer to below blog to get detail steps about configuration.

    Standard transactional replication from on-premise SQL to 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".