Hi.
I have to build a system which uses 2 databases. One is a central database for all user and second is database only for single user and it is local copy of central database. The local database is used when user doesnt have internet connection to central database. In other cases the central database is used. Each db has exacly the same table structure and it is the same RDMS.
I have problem with create tool to synchronize data between local and remote database. I have created a simple application that use sql querys for checking diffrences and sending records from local to remote db. and in the opposite direction (from remote to local) i just read entire tables and put it in local db. I understand that it isnt the bast way - it needs user to make several actions and it will be painful when databases grows.
Is there any way to use Cayenne to synchronize this to database? I dream of something that runs in background, without user knowing of synchronization( But it isnt neccesary).
Thanks for any help
Jacek
This archive was generated by hypermail 2.0.0 : Tue Jan 24 2006 - 11:54:29 EST