SQL Server merge replication: When is data visible to the receiving side?

Hi,

I use merge replication to collect data from a number of agents into a central location (HQ), then process the data in the HQ.
The data that is being sent in comes from a number (4) different tables.
I'd like to be sure that processing (in the HQ) starts only when all data has been received.

Can anyone tell whether data is transferred in a single transaction or not?
If so, what is the isolation level of that transaction? Is data visible only when the transaction complete?
In SQL Server 2005 can I configure how a publication be

July 13th, 2013 10:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics