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 |
|
abdul
Starting Member
28 Posts |
 Posted - 2006-09-18 : 08:14:07
|
| What is the difference between one way continious merge replication and transactional replication?Thanks...abdul |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-18 : 09:41:06
|
| Replication is my favorite topic :-)-- First of all by default Merge Replication is not one way when you configure it for the first time. By default it will act as Bi-Directional.-- You need to manually add this parameter to the merge agent profile to let merge replication act as a one way replication its "-ExchangeType"-ExchangeType [1|2|3]Specifies the type of exchange. A value of 1 indicates a push exchange. A value of 2 indicates a pull exchange. A value of 3 indicates a bidirectional exchange (default).-- Coming back to difference between one way merge and transactional(without immediate and queued updating)a.) Logically speaking there is no difference with the end results of the Replication.b.) Merge will consume less Network Resources are compared to Transactional. So go for merge if the network bandwidth is a constraint at your end.c.) Merge is tough to recover from or manage if broken, transactional replication is easy to recover and much simple to understand and manage as compared to merge.ThanksRishi Maini |
 |
|
|
|
|
|
transactional vs merge rep.