Syncing dB

Developers Databases
#1

What would be recommended method of synchronizing databases. In this case there would be a master dB on the server (MySQL) and local database SQLite (either on desktop PC, or mobile device). Synchronization must be Bi-Directional and initially manual (perhaps automated in the future)

Arthur

#2

Re: Syncing dB

By hand make the scripts and use odbc or dao. You could use tools like odbc sync (or others). but often you only want to sync specific tables so a self made script is often easier. Ayway you’ll find enough hits on odbc sync in google.