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

Question

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.

Answer 1

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

Answer 2

Hi @chetan Vishwakarma ,

Yes, it is possible.

Your scenario is like below screenshot.

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".