From:       To:      

Home > Documentation > MS Access to MySQL > Tutorial

Step 1 of 7. Select Conversion Mode

Specify how Access to MySQL conversion tool should manage the migration process. The converter provides two options of exporting MS Access database into MySQL:
  • Move to MySQL server directly - migrate Microsoft Access database to the target server directly. MySQL server must be launched and grant the user sufficient privileges to write into database. See Connect to MySQL Server article for related information.
  • Store into dump file - following this way, the program exports the MS Access database into a local SQL script file instead of moving it to MySQL server directly. The script file contains SQL statements to create all tables (along with indexes and constraints) and to fill them with the data. See Import MySQL dump files article for related information.

Have questions? Contact us