SQL Server 复制SQL Server Replication

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance

复制是一组技术,它将数据和数据库对象从一个数据库复制和分发到另一个数据库,然后在数据库之间进行同步以保持一致性。Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. 使用复制,可以通过局域网和广域网、拨号连接、无线连接和 Internet 将数据分配到不同位置以及分配给远程或移动用户。Use replication to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

事务复制通常用于需要高吞吐量的服务器到服务器方案(包括:提高可伸缩性和可用性、数据仓库和报告、集成多个站点的数据、集成异类数据以及减轻批处理的负荷)。Transactional replication is typically used in server-to-server scenarios that require high throughput, including: improving scalability and availability; data warehousing and reporting; integrating data from multiple sites; integrating heterogeneous data; and offloading batch processing. 合并复制主要是为可能存在数据冲突的移动应用程序或分步式服务器应用程序设计的。Merge replication is primarily designed for mobile applications or distributed server applications that have possible data conflicts. 常见应用场景包括:与移动用户交换数据、POS(消费者销售点)应用程序以及集成来自多个站点的数据。Common scenarios include: exchanging data with mobile users; consumer point of sale (POS) applications; and integration of data from multiple sites. 快照复制用于为事务复制和合并复制提供初始数据集;在适合数据完全刷新时也可以使用快照复制。Snapshot replication is used to provide the initial data set for transactional and merge replication; it can also be used when complete refreshes of data are appropriate. 利用这三种复制, SQL ServerSQL Server 提供功能强大且灵活的系统,以便使企业范围的数据同步。With these three types of replication, SQL ServerSQL Server provides a powerful and flexible system for synchronizing data across your enterprise. Windows Server 2012Windows Server 2012Windows 8Windows 8都支持复制到 SQLCE 3.5 和 SQLCE 4.0。Replication to SQLCE 3.5 and SQLCE 4.0 is supported on both Windows Server 2012Windows Server 2012 and Windows 8Windows 8.

新增功能What's new

  • SQL Server 2017 未向 SQL Server 复制引入重要的新功能。SQL Server 2017 has not introduced significant new features to SQL Server replication.
  • SQL Server 2016 未向 SQL Server 复制引入重要的新功能。SQL Server 2016 has not introduced significant new features to SQL Server replication.

有关后向兼容性详细信息,请参阅复制后向兼容性For backward compatibility information see, Replication Backward Compatibility

复制安全性Replication security

发布和分发Publishing and Distribution

发布和项目Publications and Articles

快照选项Snapshot Options

筛选数据Filter Data

事务复制选项Transactional Replication Options

合并复制选项Merge Replication Options

管理订阅Manage Subscriptions

同步订阅Synchronize Subscriptions

管理Administration

监视Monitor