Table of Contents
Basic research is what I am doing when I don't know what I am doing.
Before we can start creating synchronization applications, we have to take a look at certain synchronization concepts first. And even before that we need to find out what is meant by synchronziation.
We define two databases as synchronized whenever their contents are equivalent. Whenever their contents are not equivalent, the databases are unsynchronized or out of sync. It is important to note that equivalent does not necessary mean exactly equal.
Having said that, how do we get two databases to be synchronized and how do they get out of sync?
The easiest way of synchronizing two databases is by replication. With replication the master database is simply copied over the content of the client database. After that process, the former client data is lost, but both databases have the same content.
Databases get out of sync, when at least one database operation is applied to one database and not the other.