1 Subscriber with 2 Publishers !!

Question

1 Subscriber with 2 Publishers !!

Adel Khayata

SSC Rookie

Points: 41
More actions
July 27, 2006 at 8:01 am

#171683

Hi.
I have SQL 2005 Merge Replication already implemented.
I have one main SQL Server 2005 which is serving as the Publisher for my Articles which is located outside my city.
I have setup all remaining Servers to be subscribers to this server over VPN connection to this server.
Now ... All subscribers have to connect through VPN to the Main Server to Replicate Data.
One of these subscribers is located at our branch which is a desktop computer.
Even Mobile users with notebooks have to connect to this server to replicate.
I want these Mobile Users to replicate data with the Main Server when they are outside our local network, but also to be able to replicate data locally with the local subscriber at our network which means that these Mobile Users will be subscribers to 2 Publishers.
Is it possible to be done?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

BeerBeerBeer SSCarpal Tunnel Points: 4021 More actions · Answer 1

If you are not replicating the same tables I would imagine you could, but if you have an overlap with the same table being replicated from both servers, I would expect you might struggle to acheive this particular architecture.

If you have two "servers" available within your test environment you should be able to set it up as described and find out for sure.

Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

Adel Khayata SSC Rookie Points: 41 More actions · Answer 2

Thanks for your reply.

I meant that I want to replicate the same tables from two Publishers because the two publishers are using the same articles.

BReuter Ten Centuries Points: 1325 More actions · Answer 3

In 7/2000 there was a concept of "alternate sync partner" which was intended to handle disaster situations, but could work here as well. Bascially your local publishers would republish the primary publisher's data (which you are already doing). The mobile subscribers would subscribe to their local server, with the primary configured as an alternate. The caveat is you must sync with the local server every X days, where X = metadata retention window.

Unfortunately this feature is deprecated in 2005 so you'd be on your own if you uncovered any bugs.