SQL Server 2005 Merge Replication Subscriber unexpectedly deleting during data Synchronisation.
Within my current project I have been using SQL Server 2005 merge replication. While I have been testing some issues have been raised by our testers and I would like to write about another one of these in particular. Data, which was entered at the subscriber, was being removed while synchronizing with the publisher. This can happen when the data entered isn’t part of the partition for a given subscriber. However, on this occasion we expected the data to remain in place. After some investigation by me and my colleague, James Rowland-Jones , we found the issue. We noted that the affected tables were organised in parent child relationships at a table / schema level but they were joined child parent in the replication topology. They were joined via a join filter with a partition filter on the child record. So Customers 1 -> N Orders but partitioned On Orders with a join filter back to Customers. The topology was created in this way to help partition the data sent to the indiv