Merging & Overwriting

Access-to-MySQL Pro has been desingned for bulk database conversion. To not ask user each time when the destination database exists, the program allows to specify how to process existing tables for each database. Access-to-MySQL Pro provides several options: overwrite, merge or skip.

• 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.

You can select one of these options using 'Conversion Item Properties' dialog box. See Conversion Item Properties article for related information.