HiveBrain v1.2.0
Get Started
← Back to all entries
gotchaMinor

What is the difference between 'two way transactional replication' and 'peer to peer replication'?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thewhattransactionalwaypeerreplicationdifferencetwobetweenand

Problem

Can someone explain in detail the exact differences between 2 way transactional replication and peer to peer replication?

Solution

generally transactional has a publisher and a subscriber, with some updating from the subscriber, peer to peer replication shares the same data in more of a node environment (often over long distances) and would be more suitable for load balancing.

I'd go straight to technet for the overview http://technet.microsoft.com/en-us/library/ms151196.aspx

Context

StackExchange Database Administrators Q#24390, answer score: 2

Revisions (0)

No revisions yet.