I have a Merge Replication installation going on with about 35 connected devices. When one of the subscribers synchronizes, do the inserted rows appear sporadically on the publication database at different times? Or do they appear all at once?
Can all of these be isolated inside a transaction - this would seem like it should be the default behaviour, in case of a sync being cancelled or failing due to loss of connectivity etc.
The reason for this question is that another part of the system seems to have queried the publication database during and after a subscriber synchronization with differing results.
If this is normal, what would be the best solution to ensure data integrity?
Thank you in advance.
View Complete Post