I am trying to replicate two databases that are on the same server (this is
a test). I use merge replication in MS SQL Server 7.0. I have created a
dynamic filter for the publication. This filter is based on the subscriber
username. The subscription I use is a Pull subscription.
The table I publish contains 3 columns : a global unique id, a user name,
and a text column.
I can add and insert rows in the publisher database and the changes appear
at the subscriber (if the added or updated rows contain the subscriber's
username). I can also add or update rows at the subcriber and the
modifications are updated at the publisher.
Now is the PROBLEM (or question).
Is it normal that ALL the rows that I add at the subscriber appear at the
publisher (even the ones that DO NOT contain the username used in the merge)
Also, is it normal that the rows added at the subscriber that do not contain
the username used in the filter are deleted at the subscriber?
I can't find these answers anywhere...
Thank you in advance for giving me the answers to my questions.