Posted - 09/11/2012 : 13:49:46
I would like to know what replication model I should use to achieve the following if even achievable. This is a simplified example.
Database 1 (DB1)Contains a table with client A, B, C, D.
Database 2 (DB2) Contains a table with client B, E, F,G
As you can see booth DB's share a common client B.
I only want to replicate the data for Client B between the two DB's
I must use merge replication as transactions are entered in both DB's.
I do not want to replicate any of the other clients.
What I have done.
1. I have setup a filter on DB1 (Publisher - Merge Replication)to filter client B. The problem is:- I can now only see Client B at DB2 (Subscriber) and if I insert a new record for any other Client other than B it is automatically removed for DB 2 when I sync.
2. So I tried republishing. The problem is:- When I modify Client B at Subscriber it causes a conflict at the Republisher. I am not sure if I setup republishing correctly.
I would appreciate any assistance.