Replication methods

Hi,

I'm a newbee to replication and wanted to know about the whole mechanism of replication and how is two way replication implemnted on 2 diffrent servers located at 2 different remote locations?

Replication is a huge subject, but it depends on what your requirements are.

Can data be entered at both locations, and do you want data sent both directions? If so, you want Merge replication.

I think that before we give you an educated answer, you need to provide us with a few more requirements of what you are trying to accomplish. The reason I say this is becuase a blanket statement like "how does replication work" would take volumes to answer. I'm not trying to be rude, just trying to get a little more information so we can best answer your question, only because there are so many aspects and types of replication.

However, it is certainly possible to implement replication with 2 different servers located at 2 different remote locations. It just depends on how you want it implemented and your data requirements.

|||Basically triggers fire and write enteries in tracking tables which refer to the row and table which was updated.

When the merge agent runs it consults these tables to determine what changed on the subcriber since the last time it ran. It then uploads this list to the publisher and processes the deletes first. It compares the changes which have occured on the publisher and subscriber and if any of them have occured on the same row, this row is marked as a conflict and the conflict resolution mechanims kicks in.

Then the merge agent begins to fill in changes which have occured on the publisher to the subscriber and vice versa.