September 13, 2005 at 3:08 am
If you have setup merge replication, it will automatically handle sending the changes to all the subscribers. You don't have to do anything but synchronize the subscribers.
Incase you want to recreate the complete database you will have to use snapshot replication (But for daily update you should use ransactional or merge replication)
Transactional - if publisher and subscribers are constantly/frequently connected
Merge- If the subscriberand publisher remain disconnected for a significant time
September 13, 2005 at 7:47 am
Hi,
It looks like Merge replication would suit you here. If your central database is the publisher you can have 4 subscribers. As each subscriber makes a change, it will be replicated to the publisher and then out to the other subscribers. If there is any loss in connection then the transactions are queued.
HTH Graeme
September 13, 2005 at 1:17 pm
Thank you thank you thank you Graeme.
As Homer Simpson would say, "D'Oh!" I had been making the satellite offices the publishers. When I made the main web db the publisher, and made the satellite offices the subscribers, everything worked the way it should!
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply