I am facing Issues for data replication of specific tables (Bi-Directional) in SQL databases at two different regions hosted on Azure Cloud.

Question

Hi,

I have SQL Databases in Europe Region & USA Region hosted on Microsoft Azure cloud. I want to sync specific tables of both databases. I have researched about database replication approach (Transactional Replication, Snapshot Replication, Peer-to-Peer Replication, Merge Replication). But it seems that Azure SQL server doesn't provide the feature of Replication. So, I am not able to do that.

For Geo-replication I have read that it will replicate full Database and secondary data will be read only. But I don't want full DB replication and not read only database. Secondary DB should also be Read/Write DB and data should sync Bidirectionally.

Please provide me some helpful information for this.

Thanks

RituRaj

Answer 1

Hi Raj, Ritu •,

Welcome to Microsoft Q&A forum.

As I understand, you want to set-up Bidirectional sync between 2 Azure SQL Databases created in 2 different Regions.

Thanks for the details provided about your research and you are right that currently Azure SQL DB does not support Bidrectional Replication.

However, this could be accomplished by SQL Data Sync illustrated here: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql which again has a prerequisite that the Sync Metadata Database has to be an Azure SQL Database located in the same region as the Hub Database, which is not in your case.

So, as a workaround I would suggest you to try Azure Data Factory for sync using Trigger option as described here in the article:

https://community.nintex.com/news-18/using-azure-data-factory-to-replicate-on-premises-data-17825

Let me know if you face any issue or have any query.

Thanks