Migrating from Access (*.mdb,*.accdb) to MySQL

This article explains how to using ESF Database Migration Toolkit to migrating from MS Access to MySQL in 3 easy steps.

Requirements:
Windows XP or higher.
ESF Database Migration Toolkit download.
Microsoft 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 Data Destination" dialog, choose "MySQL Database"

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

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

  • Select the tables which will be migrated.
    Select Tables&Views

  • Click "..." to setting the table options or re-map the table structure.
    Transform

4). In "Execution" Dialog

  • Click "Submit" to starting migration, this tookit will help you 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!