How to sync data between from a SQL DB in Azure SQL Server to another SQL DB in a different Azure SQL Server

Question

I would like to create a single directional sync transaction between the DBs.

For Example:

Azure SQL Server 1 has DB1

Azure SQL Server 2 has DB2

I would like the changes from DB1 to be synced to DB2. But, if I create additional tables on DB2, it should not affect DB1.

I am trying to avoid Data Factory Sync, unless its the only way.

Answer 1

You can use Azure SQL Data Sync in that scenario. You can have replication on one direction or bidirectional. You can schedule the replication with a frequency of seconds, minutes, hours, days, manually. With SQL Data Sync you can add more tables to the destination database without any problem but you cannot change the schema of tables participating on a sync group without having to reconfigure the sync.

A sync group is a logical grouping of SQL Database instances and optional SQL Server databases. This grouping defines which databases, tables and columns are synchronized together. You can have many sync groups defined.