SQL Server - 事务复制（仅部分数据） [英] SQL Server - Transactional Replication (partial data only)

问题描述

我有6个月的资料，如何只复制最近3个月的资料给订阅者？

I have 6 months of data, how do I replicate only the most current 3 months of data to the subscribers?

推荐答案

您可以使用过滤的复制。当您阅读过滤复制的示例时，您可能会看到它指的是一个分支办公室场景，其中一个中心办公室存储几个分支机构的数据，每个分支只想复制自己的数据。

You can use filtered replication. When you read examples about filtered replication, you'll probably see it referring to a branch office scenario where a single central office stores data for several branch offices, and each branch only wants to replicate their own data. It involves creating filters on a key, and in your case, you'll want to use your date range as the key.

这里有一个有关使用事务复制的过滤复制的文章，以及使用合并复制过滤。

这篇关于SQL Server - 事务复制（仅部分数据）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！