February 23, 2009 at 1:07 pm
I have two SQL Server 2005 databases on different SQL Servers. Both databases have the same tables (one only has Customer related tables) and both are Publishers in Merge Replication. I have one Subscriber, which is a SQL server 2000 database. How do I configure replication to work properly? The problem I'm having is that when one publisher's data is updated the other publisher is not receiving the same updated data. The subscriber receives the data successfully.
Can someone help?
February 23, 2009 at 2:12 pm
Josh Duncan (2/23/2009)
I have two SQL Server 2005 databases on different SQL Servers. Both databases have the same tables (one only has Customer related tables) and both are Publishers in Merge Replication. I have one Subscriber, which is a SQL server 2000 database. How do I configure replication to work properly? The problem I'm having is that when one publisher's data is updated the other publisher is not receiving the same updated data. The subscriber receives the data successfully.Can someone help?
Merge is not my strongest replication type but I believe you have to make sure your subscribers are "global".
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply