SQL Server - Transactional Replication (partial data only)

Question

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

Answer 1

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.

Here's an article on filtered replication with transactional replication, and another on filtering with merge replication.

Answer 2

Thanks. I will definitely look into that. I did find the examples.