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.
1条答案
按热度按时间iq3niunx1#
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.