SQL Server 复制

2021-11-17 00:00:00 sql-server replication archive

3 种复制有什么区别?复制适用于数据归档吗?复制步骤是什么?

What is difference between 3 type of replication? Is replication suitable for data archiving? What is the replication steps?

推荐答案

以下是 SQL Server 中的三种复制类型.

Following are the three types of replication in SQL server.

  1. 事务复制
  2. 合并复制
  3. 快照复制

有关更多信息，请参见 http://technet.microsoft.com/en-我们/图书馆/ms152531.aspx

For more See http://technet.microsoft.com/en-us/library/ms152531.aspx

复制也可用于存档目的，但需要一些额外的机制.大部分时间我看到，它用于数据仓库场景，以减少OLTP系统的负载.

Replication can be used for archiving purposes as well but with some additional mechanisms. Most of the time I have seen, it is used in data warehousing scenarios to reduce load on the OLTP system.

相关文章