Azure SQL MI Replication – New Possibilities for Hybrid Environments
One of the limitations of SQL Azure database is that it can’t support a SQL agent, so replication, while possible from on-premises to the cloud, is not available in the opposite direction. One solution is the use of the relatively new Azure SQL Database Managed Instance, SQL MI, that allows replication from the cloud replicated back to an on-premises SQL database.