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.
12,706 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.
494 questions

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,091 Reputation points Microsoft Vendor
    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".