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?
Sql-server – Replicate only specific records of a table
merge-replicationreplicationsql server
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.