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

c9x0cxw0 于 2023-08-02 发布在 SQL Server

关注(0)|答案(1)|浏览(166)

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.

sql-server

来源：https://stackoverflow.com/questions/76705796/how-to-sync-data-between-from-a-sql-db-in-azure-sql-server-to-another-sql-db-in

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.

赞(0）回复(0）举报 2023-08-02

我来回答

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

1条答案

相关问题

热门标签

最新问答