Filter on trans Replication

  • I have transaction replication on several tables (sql 2k), and also use filtering.  It appears that if records are sent to the subscriber on Monday that meet the filter requirement, but on Tuesday, the records already at the subscriber no longer meet that requirement, they do not get removed from the subscriber.  Is there any way to make that happen ?? 

    Thanks for any help ....

     

     

  • They won't be removed from the subscriber because it doesn't wok like that. The filter is to specify wich transactions at the publisher are sent to the subscriber. This transactions can be deletes, inserts or updates.

    But if they don't longer adjust to the original filter of the publisher, they won't be deleted. If you need to delete them at subscribers, you will have to delete those records at the publisher and allow replication to replicate the delete or manualyy delete the records in each subscriber, but you will loose consistency between publisher and subscriber databases.

  • Agree. Filtering is handy, but it does have its downside exhibited here. I don't fault the behavior, it's just not always what you want.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply