Access-to-Mysql

Access-to-Mysql Access-to-MySQL is a reliable tool for moving data from Microsoft Access databases to MySQL server. Thanks to the direct connection with the source and target databases, the program provides better performance than solutions that use ODBC, ADO, etc. drivers. Command line support allows you to run the product automatically on a timer.

Features:

• All versions of MS Access (including MS Access 2012) are supported;
• all versions of Linux/Unix and Windows MySQL servers are supported;
• allows you to select the individual tables to be converted;
• converts indexes with all the necessary attributes;
• converts user-defined sample data using SELECT queries;
• converts the relatedness relations between tables (foreign keys);
• - saves the settings of the conversion process to a profile The ability to synchronize a MySQL database with MS Access data
• - merges MS Access data with an existing MySQL table
• - converts MS Access databases protected by a password;
• - converts MS Access databases protected by the user and group level protection;
• - supports Unicode;
• - ability to convert MS Access databases to MySQL dump files;
• - command line support

Limitations:

• Does not convert forms, reports, or Visual Basic scripts
• Does not convert system (hidden) tables
• The demo version only converts 5 records per table
• Demo version does not convert table relatedness relationships (foreign keys)