Conversion Scenarios

Access-to-MySQL Pro provides two options to convert MS Access database into MySQL data source:

• Move to MySQL server directly - use this approach to export the contents of the source database into a database on the target MySQL server. You need MySQL server launched and also necessary privileges to write into a database on the target server. See Connect to MySQL Server article for related information.
• Store into dump file - use this approach to perform deferred conversion and get more control over the process. Following this way, the program stores the contents of the source database into a local dump file instead of moving it to MySQL server directly. The resulting file contains MySQL statements to create all tables and to fill them with the data. See Importing dump files article for related information.

You can choose one of these approaches on "Advanced Settings" page of Access-to-MySQL Pro wizard using the corresponding radio buttons. See Advanced Settings article for related information.