September 6, 2002 at 11:09 am
Hi all, I'm trying to set up two-way snapshot replication, from the
main(production) server to 2 laptops.When the coordinators take the laptops with them on the road, any change they make to the database on the laptops, I want to synchronize the databases as soon as the laptops are on the network back in the office.
What I have so far is this: I set up the production server to be Publisher
and Distributor with push subscription. I set up the laptops to be
subscribers.
Now, in order for the production database to be in synch with the laptop, do
I need to set up the production server as a subscriber also?
Any help would be greatly appreciated.
September 6, 2002 at 12:01 pm
Two main ways. One is merge replication, really made for those type of situations, or transaction with immediate update/queued update subscribers. I believe it is possible to do true bi directional replication, but the two solutions here are easy enough to implement and well tested.
Andy
September 6, 2002 at 12:19 pm
Thaks, I'll take a look at both, merge and transactional replication, but if users make the changes on the database that's on the laptop, the next time the laptop is on the network, will the databases synchronize automatically?
September 6, 2002 at 3:05 pm
I dont think automatically, have to issue the sync command somehow. There is a Win component that will do it, or you could via SQL. Honestly havent tried that, but should work.
Andy
September 6, 2002 at 3:11 pm
Thanks Andy, one more question.
on the replicated database and the subscriber database, tables got created, with the following format, conflict_replicationname_articlename. Can you tell me what those are and why they get created.
Thanks
September 6, 2002 at 4:02 pm
If you use merge there is the possibility that a row could get modified on both publisher and subscriber, creating a conflict - which update wins? MS has built in support for a number of conflict resolution strategies or you can even build your own.
Andy
September 6, 2002 at 4:11 pm
I'm using snapshot, is that something I should be worried about?
September 6, 2002 at 5:46 pm
Snapshots are intrinsic to all three types of replication. I'd recommend you read everything you can find in BOL about replication and maybe read the replication chapter in a book or two at the book store before you proceed. It's not super complicated, but it's not simple either. Lot goes into deciding which type to use and how to implement it.
Andy
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply