Access to MySQL Converter is a best program that will convert Microsoft Access Databases to MySQL. Convert databases from MS Access to MySQL or from MySQL to MS Access rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! Access to MySQL is also applicable for MySQL database migration to another MySQL database or to another MySQL server. Moreover, Access to MySQL Converter is quite well for copying MS Access database to another MS Access database.
Access to MySQL Converter Freeware Features
One page interface;
Transfer data directly from one server to another;
Select tables to transfer;
Transfer password protected databases;
Supports both shared security and user-level security;
Optional transfer of indexes;
Optional transfer of records;
Optional transfer of default values in field definitions;
Identifies and transfers auto number field types;
Easy install, uninstall and upgrade;
Support for MS Access Work Groups;
No need to set up an ODBC connection, the program will handle that for you;
Automation of the conversion process with task planner scheduler;
High speed data conversion. Access2MySQL speed noticeably exceeds average showing in this category as the program works with direct access to MySQL server;
Primary keys and Indexes support ;
Foreign keys (relations) support;
MySQL schemes support.
Access to MySQL Converter Features (Pro Ver.)
Select fields to transfer;
Create a dump file;
Saving data into a MySQL Dump and PHP script for export to MySQL database;
Interactive (GUI) mode / command line mode;
Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
Unicode Support/Connection character sets support:
MULE_INTERNAL, SQL_ASCII, LATIN1, LATIN2, LATIN5, LATIN7, KOI8, ALT, WIN1250, WIN, WIN1256, ISO_8859_7, ISO_8859_8, UNICODE (utf-8);
Advanced customization options:
– partial selection for database objects to be converted;
– database objects (tables, fields, indexes, foreign keys) tuning up before conversion;
– detection of possible conversion errors on customization stage.
Sessions support – all your settings can be saved and restored later;
Data array support;
`GUID` Access database type support;
`OLE Object` packages support;
Ability to connect to MySQL database servers located on Unix-like and Windows machines;
Full documentation supplied with the software;
Multilanguage Support (English, French, Russian, German, Spanish, Italian, Greek and Danish).
Access to MySQL Converter System Requirements
Windows 8/Windows 7/Vista/XP/2000/NT (NT only with Internet Explorer 4.01)
At least 64 MB of RAM
Necessary privileges to write into database on the target MySQL server .
Using Access to MySQL Converter
In the first step you are asked to supply the file name of the Microsoft Access Database to convert. If your Access database requires you to log in you can specify a user name, password and a system database.
The destination database and MySQL server connection settings are specified as shown below. You will have the choice of placing the result in a dump file instead of transferring it directly to another MySQL database.
You can specify exactly which tables you want to transfer to the destination database. Just check the box in front of each table name you want to transfer and click next. Select tables to convert (ctrl/shift click).
Check conversion options accordly (create schema, copy data, etc. Additional transfer options can be set in the dialog shown below. Here you can specify if you want to transfer the indexes of the Access database to MySQL. You can also select not to transfer any records. This will only create the tables in the destination table and leave them empty.
In both Access and MySQL fields can have default values. When creating the tables in MySQL the program can preserve the default values specified in the Access field definition. Also auto number properties of a field can be transferred if you check the Auto number properties box.
Press Convert button to start convertion process. The transfer will now run until all the selected tables are transferred. When the transfer is done you will see a small report telling you how much data was transferred.
When conversion is finished, apply constraints and indexes (if any).
The settings of the wizard can be saved in a .ini file.
Access to MySQL Converter Freeware Screenshot
News about Access to MySQL Converter
1.0.1 (2012-03-21) Access to MySQL Converter first release.
Support about Access to MySQL Converter Freeware
Should there be any queries, please don’t hesitate to contact me by firstname.lastname@example.org.