Enabling and disabling table filters on a subscription v7
You must first define table filters in a set of available table filters in the publication before you can enable them on a subscription. See Adding a publication for information on defining table filters in a single-master replication system.
To enable or disable table filters on an existing subscription:
Make sure the publication server whose node is the parent of the publication associated with the subscription you want to change is running and registered in the Replication Server console you're using. See Registering a publication server for instructions on starting and registering a publication server.
Make sure the subscription server whose node is the parent of the subscription you want to change is running and registered in the Replication Server console you're using. See Registering a subscription server for instructions on starting and registering a subscription server.
Select the Subscription node of the subscription on which you want to enable or disable individual filter rules.
Select Subscription > Update Filter Rule.
In the Filter Rules dialog box, select options to specify the filter rules to enable or disable on the subscription. You can enable at most one filter rule on any given subscription table.
A confirmation box appears with a warning message and a recommendation to perform a snapshot replication to any subscription on which you changed the filtering criteria.
To proceed with the update to the filter rule selections, select OK.
When the update is complete, Filter Rules Updated Successfully appears.
We recommend that you perform a snapshot replication on the subscription that contains tables on which you changed the filtering criteria.
A snapshot ensures that the content of the subscription tables is consistent with the updated filtering criteria. See Performing snapshot replication for details.