Looking for an application that can help you easily migrate your MS Access database to MySQL without having to follow any tedious procedure? Transferring databases from one system to another is always a headache regardless of how big or small the database is. Therefore, database managers and administrators look out for a simple tool that can perform an export and import operations with all the variations involved. If you’re planning to migrate data from Access to MySql, you’d probably have a lot methods in mind to port databases. Before implementing any of them, try MS Access to MySQL. It is an ingeniously simple utility for Windows that is designed to quickly port Access database to user-defined MySql database. It supports a wide range of database formats, including, MDB, MDE, ACCDB, and ACCDE database formats, and also shows you the MySql database hierarchy to choose the destination database path. Furthermore, password protected (encrypted) databases can also be exported on the fly without having to decrypt them.
The application supports two transfer modes – Direct transfer and Dump file creation. In direct transfer mode, you need to enter the host address, port, DB username and password along with the DB name where data has to be directly ported, whereas the Dump file creation method lets you choose a local location to create SQL dump file for importing it later.
It has a simple wizard with 3-4 steps for transferring data. In the first step specify source database, second step refers to choosing transfer type. Depending upon the type, it will ask you to choose options in later steps. In direct transfer mode, enter the required information for establishing connection, specify the DB name, and pick out the storage engine.
In the last step of direct transfer, it will ask you to choose some database transfer-related options, such as include transfer indexes and records, Include the column list in the INSERT, create tables, enable Unicode (utf-8), create tables and transfer records. Depending upon the requirements, select the appropriate options and click Run Now to begin the process.
Creating SQL Dump file mode needs nothing except specifying the target location where you want to save the Sql file. After the transfer is completed, it is recommended to thoroughly verify the the database migration including all the included tables with indexes to prevent any conflicts in the future. It works on Windows XP, Windows Vista, and Windows 7.
Download MS Access to MySQL
Access To MySQL
Access to MySQL is a small program that will convert Microsoft Access Databases to MySQL.
- Wizard interface.
- Transfer data directly from one server to another.
- Create a dump file.
- Select tables to transfer.
- Select fields 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.
- Command line interface.
- Easy install, uninstall and upgrade.
Using Access to MySQL
When you start the program it will run you through a wizard. The wizard will ask you all the necessary questions to setup the database transfer. 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.
Specify Access 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.
MySQL connection and destination settings
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.
Selecting the tables to transfer
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.
Setting advanced transfer options
After answering all the questions in the wizard you can press Finish. 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.
The settings of the wizard can be saved in a .ini file.
You can download the latest version here. After downloading the setup program you should simply run it to install the program.
While our product offers a lot of functionality for free there is a commercial alternative. The commercial program has even more functionality but it comes at a small cost. We are an affiliate of DMSoft and if you buy any of their products then you also support our efforts to product great free software.
Commercial Access to MySQL converter