Is there a template for synchronizing data lists over the network?

Question

I have a server application that offers data to several clients over the network. You can present the data as a huge list of rows. The data on the server is subject to change and must be synchronized for all clients.

I am currently using this approach: upon initial connection, the client application requests all current data (which may be a large number of bytes). Then he subscribes to updates (add, change and delete) of any data.

This works fine if the data is not changed on the server between sending the original data list and the application subscribing to the changes. In this case, the client skips several updates and works with outdated data, not knowing about it.

I believe this is a very common scenario, so there should be a template that solves the problem. I use C # 4 and WCF, but the template should be a language agnostic, I suppose.

Answer 1

Have you looked at Microsoft Framework Synchronization for .Net. This gives you finer control over what syncs and how. WCF is fully supported. It supports incremental updates and synchronizes changes with the server.

The API is quite large and covers not only database synchronization, but also many articles. This should start:

Introduction to Sync Framework Database Sync

Database synchronization

Answer 2

, ...

" " " ", , " ", , ?

- , , .

.

void Connect()
Subscribe()

Timestamp Connect()
Subscribe(timestamp)

Answer 3

, .

, , , .

Answer 4

, .

, , .