Migrating with wizards

Using wizards to migrate your tables has the following advantages:

• They let you select some or all tables to migrate to MySQL.
• They will set most properties on the tables, as described in the Adjusting field properties section, while migrating so that you don't have to adjust them.
• There are dedicated applications available to migrate from MS Access to MySQL. However, all the ones I have tried are slower than the Workbench wizard.

However, this is where things may get a little tricky. MS Access versions 95 to 2010 included the Upsizing Wizard, which always handled upsizing well, but Microsoft removed it in version 2013.

How you approach the data migration process will depend on your specific MS Access version and MySQL setup. Let's see what we can do with a variety of setups:

• MS Access 2010 or earlier: You can use the Upsizing Wizard on the ribbon to access Database Tools, Move Data, and SQL.
• MS Access 2013 or...