I've been searching all over the net for a sutable solution of this problem, but I can find nothing.
So the problem is
for example you have a server with a database and several client coputers, that fill the server. But all the clients do have local databases, so that the systems can work in case of internet connection lost. But I cant find the solution that will synchronize the local databases. When a client fills the server with the new data it has on the local database how do you know whick are the new rows and when the other computers do a synchronization how do they know whick records to take from the server.

Please help me.