MySQL to MS Access Migration and Sync

The software is intended for cross database migration and synchronization from MySQL to MS Access. Synchronization will keep your databases coherent and up-to-date.

Setting up a migration process is flexible enough and easy to operate even for non-specialists. A lot of options allow setting up the process precisely to get the desired results. 

Combining Insert Synchronization, Update Synchronization and Drop Synchronization methods allows you to accomplish the process of data upload and mirroring flawlessly.

Command line mode allows migration jobs to be scheduled and automated.

Read here trial versions limitations

Product highlights

• Views conversion from MySQL to MS SQL and Oracle and back support
• Saving data into a MySQL Dump and PHP script for export to MySQL database
• Ability to connect to MySQL Server 4.x/5.x located on Linux, Solaris, Mac OS X, Windows machines
• Speed conversion with Bulk and Quantization features
• Access queries to MS SQL, MySQL and PostgreSQL views conversion support
• MS Access Work Groups support
• Linked tables support
• Also see common features for all DBConvert tools

Requirements

• Necessary privileges to write into database on the target MySQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)
• Access 2000 or higher
• Microsoft Visual C++ 2008 x86 Redistributable package