I am after some advice as to my replication setup and what I can do with it. I have only basic knowledge of replication but have had transactional replication setup for a while now which replicates a few of the main databases tables and it is working
fine. However we want to improve performance of our subscriber database, so I would like to use row filters for this.
Imagine the setup of a database table for Questionnaires which has a Void bit field in it, and a table for Answers. On the subscriber I want only non-void Questionnaires and their answers. So I set the row filter for the Questionnaire table to be "WHERE
Void = 0", I think this works. However, I don't think it works when I am working on the Answers table, my row filter would be "WHERE QuestionnaireID IN (SELECT QuestionnaireID FROM Questionnaires WHERE Void = 0).
This works fine for the initial snapshot but not for following transactions. For example, if I made a Questionnaire not void then I'd expect that to make its way to the subscriber along with its answers. Or if I voided a Questionnaire I'd expect that Questionnaire
and set of answers to be removed from the subscriber database.
I have read that this type of filter that uses a subquery only works with merge replication, if my understanding is correct?
So my question here is, can you validate my findings, is
View Complete Post