Access-to-MySQL is a program to move MS Access databases to MySQL server. Key features include all MS Access data types and attributes are supported, works with all versions of MySQL server, converts indexes with all necessary attributes, converts individual tables, converts relationships between tables, merges MS Access data into an existing MySQL database, converts password protected MS Access databases, exports MS Access databases into MySQL dump file, easy-to-use wizard style interface.
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
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
What's new in this version: Version 4.3 convert MS Access queries into MySQL views.
