Accuracy of replicated data

Hi,
I use dial-up connection to replicate data between to servers. Our
replication type is Merge and I'm worried that what happens if the
connection fails when merge agent is working. Will the synchronization be
rolled back or I must necessarily use Transactional replication?
Thanks in advance,
Leila
"Leila" schrieb:

> Hi,
> I use dial-up connection to replicate data between to servers. Our
> replication type is Merge and I'm worried that what happens if the
> connection fails when merge agent is working. Will the synchronization be
> rolled back or I must necessarily use Transactional replication?
> Thanks in advance,
> Leila
Test it (it should be rolled back - and even if not: the next execution of
the merge agent should synchronize the publisher and subscriber again)!
If you you do not need bidirectional replication it is better to use
transactional replication anyway - it's faster and (unlike the merge
replication) guarantees the consistency of your data!
|||Thanks Christian,
But I'm trying to understand its logic without testing. Because my data are
important and sensitive and I cannot risk for testing!
"Christian Donner" <ChristianDonner@.discussions.microsoft.com> wrote in
message news:44A7E2F0-23EC-490E-82CD-820D15257830@.microsoft.com...[vbcol=seagreen]
> "Leila" schrieb:
be
> Test it (it should be rolled back - and even if not: the next execution of
> the merge agent should synchronize the publisher and subscriber again)!
> If you you do not need bidirectional replication it is better to use
> transactional replication anyway - it's faster and (unlike the merge
> replication) guarantees the consistency of your data!