Conversion Item Properties

This dialog is designed to add new MS Access database for converting or to edit an existing one. First you should enter MS Access database path and MySQL database name or path to a dump file (depending on which conversion scenario you choose). If you specify the name of an existing MySQL database or dump file it will be overwritten.

If the source MS Access database is password protected you should select "Use database password" checkbox and enter the password in the field below.

You can convert only table definitions of the original MySQL database. Select "Convert table definitions only" checkbox at the bottom of the dialog box to use this feature. If you don't want to convert indexes select "Skip converting indexes" checkbox.

When migrating databases to MySQL server directly, you should also specify how to process existing tables (if the destination MySQL database already exists).

• Select 'Overwrite' option to replace the contents of existing MySQL tables with MS Access data.
• Select 'Merge' option to merge MS Access data into the destination MySQL database. Access-to-MySQL Pro implements quite simple merging algorithm. If a table has primary key or an unique index, the program inserts into MySQL database only those records whose key/index value does not exist in the destination MySQL table. Otherwise, Access-to-MySQL appends the whole table contents to the corresponding MySQL table. If the structures of source and destination tables are different, the program transforms each record of the source table so that it conforms to the destination table structure.
• Select 'Skip' option to not convert tables that already exist in the destination database.