iilv
asked on
Sqlite & Mysql Synchronization
Hi,
I am developing a desktop internet enabled application in Adobe AIR with HTML & JavaScript. It will have a local database(sqlite) to store data. The application will also have an associated web site with data stored in MySQL.
I need to synchronize the data on the server and on the desktop periodically. Synchronization has to work both ways i.e. updated information on the server should be transmitted to the local database and vice versa.
Is there any in-built function/command/script that manages this synchornization both ways(local to remote & vice versa).
I am developing a desktop internet enabled application in Adobe AIR with HTML & JavaScript. It will have a local database(sqlite) to store data. The application will also have an associated web site with data stored in MySQL.
I need to synchronize the data on the server and on the desktop periodically. Synchronization has to work both ways i.e. updated information on the server should be transmitted to the local database and vice versa.
Is there any in-built function/command/script that manages this synchornization both ways(local to remote & vice versa).
ASKER
I am sorry. I forgot to mention that we would be using PHP to access
the server side database.
Therefore what I am looking for is a PHP script that compares and
synchronizes the two databases.
the server side database.
Therefore what I am looking for is a PHP script that compares and
synchronizes the two databases.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Take a look at the tool for SQLite and MySQL synchronization at http://dbconvert.com/convert-sqlite-to-mysql-sync.php?DB=10
Another alternative could be to use Flex/AIR based MySQL drivers to directly access and update it. Check this out: http://code.google.com/p/assql/
- lexxwern