Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-02-02 : 01:21:02
|
| what is the difference between Regular Transactional replication andPeer to Peer Transaction Replication?--Ragu ThangavelJunior SQL Server DBA |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-02 : 09:56:46
|
| In Peer to Peer, all subscribers are also publishers.http://technet.microsoft.com/en-us/library/ms151196.aspx |
 |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-02-04 : 01:11:26
|
| all subscribers are also publishers thendata's are transfered both sides.it's true?the above assumption is true then Merge Replication also do the same thing. so why we are using Peer to Peer Transaction Replication?--Ragu ThangavelJunior SQL Server DBA |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-04 : 07:52:21
|
| They are not the same thing, though similar. Their practical application is different as well.Peer to Peer, is like transactional (in fact it IS transactional), in that you typically distribute in (near) real time. It is both a scaleout and a HA solution. You keep multiple database servers in synch, and clients can connect to them -- even from geographically dispersed locations. All servers are "live" all the time. There is NO built-in conflict resolution in peer to peer either.Merge Replication is typically used for smaller clients to synch their updates with the publisher. Think of a fleet of salespersons or census takers each with a small database backed app, who "upload" their data every night, or every week.Have a look here |
|
|
|
|
|
|
Transactional Replication