I am trying to achieve the following.
*Server ‘A’ is in a datacenter
*Server ‘B’ is in LA
*Server ‘C’ is in NY
*I have SQL 2000 server ‘A’, ‘ B’ and ‘C’ all containing database name X. Database X has table T.
-I want to setup server ‘A’ to selectively replicate certain rows in the table T according to some type of filter(s) with servers ‘B’ and ‘C’.
-i.e Between server ‘A’ and ‘B’, replicate rows where SystemID = “SystemB” in table T to table T in the server ‘A’ where SystemID=”SystemB”.
-i.e Also Between server ‘A’ and ‘C’, replicate rows where SystemID = “SystemC” in table T to table T in the server ‘A’ where SystemID=”SystemC”.
-I want users of server ‘B’ to be able to update data in server ‘A’ as well.
-I want users of server ‘C’ to be able to update data in server ‘A’ as well.
-Server ‘A’ should have data from servers ‘B’ and ‘C’. Server ‘A’s Table T in database X will contain “SystemB” and “SystemC” under SystemID column.
-I do not want server ‘B’ to obtain any information from server ‘C’, through the replication process. Replicated data between server A and B should only stay in ‘A’ and ‘B’.
-I do not want server ‘C’ to obtain any information from server ‘B’, through the replication process. Replicated data between server ‘A’ and ‘C’ should only stay in ‘A’ and ‘C’.
-Future plans to add in more servers at different sites that will connect to server ‘A’.
-Additional requirement is that I can’t change the name of the database
I have been trying to achieve this by trying merge replication with horizontal filters. I had server ‘A’ as subscriber and server ‘B’ and ‘C’ as publisher using push publication. I have been playing with the filter but I’m at a dead end.
*Server ‘A’ is in a datacenter
*Server ‘B’ is in LA
*Server ‘C’ is in NY
*I have SQL 2000 server ‘A’, ‘ B’ and ‘C’ all containing database name X. Database X has table T.
-I want to setup server ‘A’ to selectively replicate certain rows in the table T according to some type of filter(s) with servers ‘B’ and ‘C’.
-i.e Between server ‘A’ and ‘B’, replicate rows where SystemID = “SystemB” in table T to table T in the server ‘A’ where SystemID=”SystemB”.
-i.e Also Between server ‘A’ and ‘C’, replicate rows where SystemID = “SystemC” in table T to table T in the server ‘A’ where SystemID=”SystemC”.
-I want users of server ‘B’ to be able to update data in server ‘A’ as well.
-I want users of server ‘C’ to be able to update data in server ‘A’ as well.
-Server ‘A’ should have data from servers ‘B’ and ‘C’. Server ‘A’s Table T in database X will contain “SystemB” and “SystemC” under SystemID column.
-I do not want server ‘B’ to obtain any information from server ‘C’, through the replication process. Replicated data between server A and B should only stay in ‘A’ and ‘B’.
-I do not want server ‘C’ to obtain any information from server ‘B’, through the replication process. Replicated data between server ‘A’ and ‘C’ should only stay in ‘A’ and ‘C’.
-Future plans to add in more servers at different sites that will connect to server ‘A’.
-Additional requirement is that I can’t change the name of the database
I have been trying to achieve this by trying merge replication with horizontal filters. I had server ‘A’ as subscriber and server ‘B’ and ‘C’ as publisher using push publication. I have been playing with the filter but I’m at a dead end.
