Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deonvisser
Starting Member
16 Posts |
 Posted - 2012-09-11 : 13:49:46
|
| HiI 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,GAs 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'sI 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.Kind RegardsDeon |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-11 : 14:32:45
|
| http://msdn.microsoft.com/en-us/library/ms151775.aspx-Chad |
 |
|
|
deonvisser
Starting Member
16 Posts |
Posted - 2012-09-11 : 15:14:59
|
| Thanks ChadUnfortunately replication filtering removes all non filtered clients from the subscriber, only leaving B at the subscriber and removing E, F and G. |
|
|
|
|
|
|
Can this be done with replication?