sql-serverazureazure-sql-databaseazure-data-sync

Azure SQL as Publisher

I want to replicate data on PaaS Azure SQL to IaaS SQL Server Instance. Can I use SQL Serer Replication (Not Azure Geo Replication) to replicate data from Azure SQL to SQL server Instance onPremises/IaaS Platform. Here Azure SQL will act as a publisher as well as distributor whereas onPremises/IaaS SQL Server Instance act as subscriber. I know you can replicate data from OnPremisis to Azure SQL but I want other way around.

Thanks for the Anticipation.

Thanks and Regards, DK.

Solution

  • You can make use of SQL Data Sync. To learn how to setup and configure it, please use this article.

    Hope this helps.