Transaction Replication ??

[Anukul]

Hi All:

What is Bi-Directional Transaction Replication? How is it different from
Merge replication?

Thanks,
Anukul

[Hilary Cotter]

In Bi-directional replication transactions which occur on both the publisher
and the subscriber are replicated to the other node. In the case where a
transaction occurs on the publisher it is replicated to the subscriber. In
the case where a transaction occurs on the subscriber it is replicated to
the publisher.

There are several variants of this. Merge, Bi-directional Transactional
replication, transactional replication with immediate updating,
transactional replication with queued updating, and transactional
replication with immediate updating and queued failover.

With merge replication if a conflict occurs, the loosing transaction is
logged in tables. You can reverse/rollback the conflict resolution. With
Transactional replication with immediate updating or queued updating,
conflicts are logged but can't be rolled back. You can set up Publisher
Wins, Subscriber Wins, or Publisher Wins and resends the snapshot.

With pure bi-directional transactional replication the subscriber also
publishes back to the subscriber. Any conflicts require manual intervention
as the agent will stop.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Anukul" <anu...@yahoo.com> wrote in message
news:%235kPXvo...@TK2MSFTNGP10.phx.gbl...

[Anukul]

Thanks Hilary!

Answers my query to a large extent.

Although I had asked this based on ur response to my earlier thread:  Please suggest type Of Replication suitable in this scenario !

I have asked another query on that same thread. Would u please go throught that too?

Thanks,
Anukul

"Hilary Cotter" <hilary...@gmail.com> wrote in message news:u#Fi$zo8EH...@TK2MSFTNGP10.phx.gbl...