Home ›

MySQL Migration Tool

The MySQL Migration Tool can be downloaded as part of the MySQL GUI Tools.

We will demonstrate an example of Direct Migration from MS Access (.mdb) to a MYSQL server.

  • After downloading and installing MySQL GUI Tools, run the MySQL Migration Toolkit
  • Choose Direct Migration and click Next
  • Select MS Access and locate the ".mdb" file as the source
  • Enter the host, user and password for the locally installed MySQL server
  • Select the "schema" as presented and click next.
  • Take all defaults.
  • Inspect the reports for errors and clues when things go wrong.
  • Try a few sample queries using the MySQL Query Browser.