sql 不同数据库同步数据
SQL Data Sync is a service that allows synchronizing data across multiple Azure SQL databases and on-premises SQL Server databases.
SQL Data Sync是一项服务,允许跨多个Azure SQL数据库和本地SQL Server数据库同步数据。
In this article, a base concept of how the SQL Data Sync service works will be explained as well as what the requirements and limitations are when want to create data synchronization by using SQL Data Sync
在本文中,将解释有关SQL Data Sync服务如何工作的基本概念,以及当希望使用SQL Data Sync创建数据同步时的要求和限制。
To synchronize data and the period, the sync group needs to be created and the databases, tables and columns should be defined.
要同步数据和时间段,需要创建同步组,并应定义数据库,表和列。
The base concept of data synchronization with SQL Data Sync is shown on the image below:
下图显示了使用SQL Data Sync进行数据同步的基本概念:
SQL Data Sync uses a hub- spoke topology to synchronize data. In the sync group (e.g. Sync Groupe 1), one database is defined as the Hub database (must be an Azure SQL database) and the rest of databases under the sync group are the members databases. The data synchronization appears between the Hub and individual member database only.
SQL Data Sync使用中心辐射拓扑来同步数据。 在同步组(例如, 同步组1 )中,一个数据库定义为集线器数据库 ( 必须是Azure SQL数据库 ),同步组下的其余数据库是成员数据库 。 数据同步仅出现在集线器和单个成员数据库之间。
The member databases can be Azure SQL databases, on-premises SQL Server databases or SQL Server instance on Azure virtual machines.
成员数据库可以是Azure SQL数据库,本地SQL Server数据库或Azure虚拟机上SQL Server实例。
The data synchronization direction (Sync) can go in both directions (bi-directional) or in one, from the hub database to a member database (Hub to Member) and vice versa, from a member database to the hub database (Member to Hub)
数据同步方向( Sync )可以从集线器数据库到成员数据库( 集线器到成员 ) 双向 ( 双向 )或从一个成员数据库到集线器数据库( 成员到集线器 ) 双向 ( 双向