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.
Key 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
- 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
- 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
- Easy-to-use wizard-style interface
- Full install/uninstall support
Virtual Server users option
If you are using Virtual Server hosting you probably have no sufficient privileges to create new databases on the target MySQL server. For this case we recommend the following approach:
- ask your Virtual Server administrator to create blank database for you
- run Access-to-MySQL and select this database as the conversion target
- click "Yes" when you will be asked if you'd like to overwrite existing MySQL database
When you complete these steps, the entire contents of source MS Access database will be imported into the specified MySQL database.
What is new in this release:
Version 5.3 convert MS Access queries into MySQL views.
Limitations:
5 records per table trial
Comments not found