Migrating from MS Access(*.mdb; *.accdb) to MySQL

This document describes how to quickly migrate from MS Access to MySQL in 3 easy steps using ESF Database Migration Toolkit.

Requirements:

  • Windows XP or higher.
  • ESF Database Migration Toolkit download.
  • MS Access 97 or higher.
  • MySQL 3.23 or higher.

Introduction:

1. In "Choose a Data Source" dialog, Choose "Microsoft Access (*.mdb)" or "Microsoft Access 2007-2012 (*.accdb)";

  • Press "..." button to select the Access database (.MDB or .ACCDB) file.
  • If there is a workgroup(system database), press "Lock" button to set it.
  • MS Access

2. In "Choose a Destination" dialog, choose "MySQL";

  • Input the server name(default: localhost), port (default: 3306), username, password.
  • MySQL supporting some different Storage Engines, please click here to get more information about MySQL Storage Engine.
  • Choose a character-set, e.g.: UTF-8.
  • Press "Refresh" button to list all MySQL databases automation, you can select a database name directly, or input an new name, this toolkit will create the new database automation in converting.
  • MySQL

3. In "Select source Tables(s) & View(s)" dialog

  • Select the tables/views that will be migrated.
    Select Tables&Views

  • Click "..." to set the table options or remap the table structure.
    Transform

4. In "Execution" Dialog;

  • Click "Submit" to begin the migration, this tookit will help you quickly migrate data from MS Access to MySQL without intervention.
    Execute

5. Finished!

If you have any questions or suggestions, please contact us. Thank you for your time!

Download Now! »