Sql-server – Replicate only specific records of a table

merge-replicationreplicationsql server

I have setup a merge replication and have got a new requirement:
The records of a table should not be replicated until the [state] column is changed from 0 to 1. I have created a filter for the replication to limit replication to records with state = 1, but now the records are removed from the subscriber when the state is set to 0.
Is it possible to keep those records on the subscriber?

Best Answer

Not with the technology you use - this is not what replication is intended to do. A filter is indeed an active filter, also removing objects. You CAN add a specific field for that that you never reset.