I am also interested in synchronizing SQLite databases. As far as I am aware, there is no support in the SQLite code for the tasks required to synchronize multiple databases. You would need meta-data indicating whether data has been added/deleted/modified along with either timestamps or update numbering in order to reconcile the changes and possibly conflicts between multiple databases.
You might want to google for the techniques employed in synchronizing PalmOS PDB files between the PDA and host. It provides table based synchronization, and seems to be a robust and efficient solution between a pair of databases. John Oliva > Does anyone know how to synchronize the data on the WinCE device with a > database on a server computer? I'm just testing the feasibility of using > SQLite for our projects that run under wireless WinCE 3.0 device. The > primary database is a Sybase database server running on Sun workstations. > The WinCE SQLite would be a subset of the Sybase database. My conceptual > problem is if we do that, how could we keep the two databases > synchronized? > The wireless computers will not always be within radio frequency (RF) of > the > database, so a large part of its work is off-line from the main Sybase > server. > > Thanks for any hints or links you may be able to provide. > > Mel Stober >
