What are the requirements for SQL Replication on Azure SQL DB Managed Instance?

by cyberdog   Last Updated December 06, 2018 15:06 PM

We are seeing if it is feasible to setup Azure SQL DB Managed Instance (SQL MI) and an Azure VM with SSMS installed for this replication scenario:

We have a vendor who needs access to our SQL Server database and can RDP into it for administration. We will be using ExpressRoute to link SQL MI to our on-prem. It seems the only way to connect to SQL MI is either using site-to-site VPN (nVet) or ExpressRoute. Our vendor needs to setup transactional replication to push data to our SQL MI which will be a subscriber. This link Replication with sql managed instance is the only guide I see but has no details.

  1. Does the vendor need a vNet/ExpressRoute connection to setup replication to our database? Or can they setup replication using our VM with SSMS client tools that is in our SQL MI vNet?

  2. If that is not possible, then I guess we need to setup the Azure VM with SQL Server and they connect to that instance to replicate. Then we need to replicate that db to the Azure SQL DB MI. This seems complicated and wonder what other options are there.

Related Questions