April 28, 2010 at 12:41 am
Hi
What is the diff between merge and peer to peer transactional replication
Reg
Binu
April 28, 2010 at 11:53 am
A LOT!
Merge replication
- is trigger based
- It uses only merge agent
- It could be set to track column changes instead of row changes
- It could optimize the final changes produced at synchronization time.
Peer-to-Peer
- Is Transaction Log based
- It needs logReader + Distribution agent
- It creates at least one procedure call per row affected
- It is only available on EE
There is a very gross summary there is a lot more but it should get you startd.
* Noel
April 28, 2010 at 10:55 pm
Hi
Thanks
can u provide some senario where merge and peer to peer can be used
April 29, 2010 at 10:07 am
Merge was designed for loosely connected systems that occasionally synchronize their data. Example SalesForce.
Peer-to-Peer was simply an extension of bi-directional transactional replication with low latency in mind.
It is useful in redundant server-to-server data propagation.
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply