convert access to mysql, access to mysql conversion, access to sql converter, access2mysql, free download
FAQ  |  Site map  |  Contact Us
About Us How to Buy Products Discounts Migration Service Support Become a Partner Articles

Access to MySQL


Latest version 6.5.3 released 07/11/2016

Access-to-MySQL converter is a tool to migrate Microsoft Access data to MySQL server. The program migrates 200 MB of MS Access data within less than 15 minutes on a modern system. Installation package includes command line version of the product to script, automate and schedule the conversion process.

Features

  • MS Access to MySQL converter works wirh all versions of Microsoft Access and Unix/Linux/Windows MySQL (including Percona, MariaDB)
  • Cloud variations of MySQL such as Amazon RDS and clearDB are supported
  • The program converts indexes with all necessary attributes
  • Relationships between tables are converted into MySQL foreign keys
  • The program can convert SELECT-queries output
  • Conversion settings can be stored into profile
  • Option to synchronize MySQL database with Microsoft Access data
  • MS Access queries are converted into MySQL views
  • Password protected MS Access databases are supported
  • Option to export MS Access data into MySQL script file
  • Option to specify MySQL charset and storage engine
  • MS Access to MySQL converter supports Unicode
  • Databases protected with user-level security are supported
  • Console version of the converter supports command line parameters
  • Quick Launch mode allows to run the conversion with the single click of mouse button
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Requirements

  • Microsoft Access/Office or Access Runtime installation
  • Necessary privileges to write into MySQL database

Limitations

  • Forms, reports and Visual Basic scripts are not converted
  • System (hidden) tables are not converted
  • Demo version converts only 50 records per table
  • Demo version does not convert queries/views and relationships between tables

    
Video Demonstration

Download trial version of Access-to-MySQL

Export into MySQL script file

Access to MySQL converter not only can migrate data to MySQL server, but also it can convert Microsoft Access database into a local MySQL script file. This approach gives experienced users more control over the conversion process. Furthermore, it can be used when there is no direct connection to MySQL server. The resulting script contains MySQL statements to create all tables and to insert the data. Click here to learn how to import dump file into MySQL database.

Quick Lauch

Access to MySQL converter allows to store all settings into a profile to reuse them in next run ("Save Settings" button on the last screen). After conversion settings have been stored, user can run the database migration tool in "Quick Launch" mode. This scenario can be used by double-clicking on a profile (.a2s) with left mouse button from Windows Explorer. Then wizard will launch the conversion process loading all settings from the specified profile.

Synchronization

Synchronization in Access to MySQL converter is implemented as combination of inserts for those records that are missing in MySQL table and updates of existing MySQL records with MS Access data. The following conditions are required for correct synchronization:

  • source and destination tables must have identical structures
  • the same primary key or unique index are defined in both source and destination tables
Let's assume that both Microsoft Access and MySQL databases have table "People" defined as below:

    People(
	ID Integer NOT NULL, 
	FName Text(50)/VARCHAR(50),
	LName Text(50)/VARCHAR(50), 
	EMail Text(50)/VARCHAR(50), 
        Primary Key (ID)
    );

The table contains the following records in MS Access database:

    2	Andrew		White		a.white@corporation.com
    3   Phil		Johnson		p.johnson@gmail.com

And in MySQL database:

    1	John		Smith		j.smith@msn.com
    2	Andrew		White		a.white@yahoo.com

After converting Microsoft Access data to MySQL in "Synchronize" mode MS Access table is kept untouched and MySQL table is modified as (pay attention to the second record):

    1	John		Smith		j.smith@msn.com
    2	Andrew		White		a.white@corporation.com
    3	Phil		Johnson		p.johnson@gmail.com

Try before you buy

Still not sure that Access to MySQL converter fits your needs? Try free demo version of the product with limited features. It converts only 50 records per database table, it does NOT convert relationships between tables and queries/views. Test the quality of demo version and order the full version if satisfied with the results.

 

Single User License
install the product on exactly one computer system
$49
Corporate License
install the product on unlimited number of machines
inside purchasing organization
$99
Two Products Bundle
order Access-to-MySQL + MySQL-to-Access, save $19.5
$58.5
MySQL Migration Toolkit
software pack to convert any data source to MySQL
and vice versa
$99