Intelligent Access to MySQL

Access-to-MySQL is a powerful and reliable tool to migrate Microsoft Access databases to MySQL server. The program has high performance due to direct connection to source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features

• All versions of MS Access (including MS Access 2010) are supported
• All versions of Unix and Windows MySQL servers are supported
• Special approach for Virtual Server users
• Converts indexes with all necessary attributes
• Converts relationships between tables
• Converts MS Access queries into MySQL views
• Option to convert individual tables
• Option to convert partial data using SELECT-queries
• Stores conversion settings into profile
• Option to merge MS Access data into an existing MySQL database
• Option to synchronize MySQL database with MS Access data
• Handles password protected MS Access databases
• Handles MS Access databases protected with user-level security
• Support for multibyte character sets
• Option to export MS Access data into MySQL dump file
• Command line support
• Quick Launch
• Easy-to-use wizard-style interface
• Full install/uninstall support
• Unlimited 24/7 support service
• 1-year subscription for updates

Limitations

• Does not convert forms, reports and Visual Basic scripts
• Does not convert system (hidden) tables
• Demo version converts only 5 records per table
• Demo version does not convert queries/views and relationships between tables

Requirements

• MS Access installation
• Necessary privileges to write into the destination database