database - SQL Server - Transactional Replication (partial data only) -

I have 6 months of data, how do I copy only the most current 3 month data for customers?

You can use filtered replication. When you read an example about filtered replication, you will probably see in the context of a branch office scenario where there is a central office store data for many branch offices, and each branch only wants to repeat its data in it on a key filter In the making, and in your case, you would like to use your date range as the key.

Here one and the other.