Difference b/w Merge & Peer to Peer Replication,

#31

Yes, Peer-to-Peer is two way. But you want to think long and hard before you implement it. In 2005,
for instance, you have no conflict detection. Say 3 nodes, and A changes something same time as B.
A's change is replicated to C. Imagine this over time and you will have chaos. It is your
responsibility to handle the situation. But even partitioning (each node owns it's own data) isn't
as easy as you might think. Just imagine a restore scenario.

2008 adds conflict detection, which helps a bit. But still you need to understand that conflicts can
occur and the consequences of such.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Noor" <naissani (AT) hotmail (DOT) com> wrote

Quote:

Peer to Peer replication is two way replication right not the one way? like the same we have in
SQL Server 2000 for Merge Replication.

Thanks

"Ekrem Önsoy" <Ekremnsoy (AT) discussions (DOT) microsoft.com> wrote in message
news:5A0CF631-B383-4D8B-B9CD-703490DDAC9F (AT) microsoft (DOT) com...
Also, there is no conflict detection in Peer to Peer Replication in SQL
Server 2005. However, this Conflict Detection feature has been added to Peer
2 Peer Rep. in SQL Server 2008.

Also, Peer to Peer Replication is available only in Enterprise Edition of
SQL Server.

This is not an answer which could be told in one or two sentences. So I
suggest you to see documents of these Replication types in BOL and here are
the links:

Peer-to-Peer Transactional Replication:
http://msdn.microsoft.com/en-us/libr...6(SQL.90).aspx

Merge Replication Overview:
http://msdn.microsoft.com/en-us/libr...6(SQL.90).aspx

--
Ekrem Önsoy

"Noor" wrote:

I would appreciate if anyone can explain me the difference b/w Merge
Replication and Peer to Peer Replication which is newly introduced in 2005.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Difference b/w Merge & Peer to Peer Replication,

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Difference b/w Merge & Peer to Peer Replication, - 09-23-2008 , 12:37 AM