Access2MySQL Pro Convertor is a program which gives an opportunity to perform MS Access (mdb) to MySQL and MySQL to Access database conversions simply by having configurated several options of wizard-like application.

Access2MySQL Pro Convertor is a program which gives an opportunity to perform MS Access (mdb) to MySQL and MySQL to Access database conversions simply by having configurated several options of wizard-like application.

Convert your dbs using professional tool. Do it faster, more reliable and comfortably. Whether you want to copy a whole database or convert a number of tables, Access2MySQL Pro is at your service.

Access2MySQL Pro is a database migration tool for data conversion from MS Access database (.mdb file) to MySQL server and MySQL db to Microsoft Access.

You can convert Access to MySQL or visa versa MySQL to Access simply by configuring several options through Wizard interface or in command line mode. Ability to organize application work using command line parameters is supplemented with a built-in scheduler so you can run the program without user input after scheduling.

Along with general functionality - data importing / exporting - this easy to use converter allows you to store your data to PHP script. When using PHP script the speed of data export will be much faster than if MS Access databases were copied to MySQL database directly because the copying to MySQL database is executed with utilization of the server where the particular script is launched.

If a direct access to your MySQL base is denied (no sufficient privileges) you can save your data into a dump file to overcome such restrictions. The primary function of the MySQL privilege system is to authenticate a user connecting from a given host, and to associate that user with privileges on to select, insert, update, and delete a database. The SELECT, INSERT, UPDATE, and DELETE privileges allow you to perform operations on rows in existing tables in a database. The privilege system ensures that all users may perform only the operations allowed to them. Thus in case you have no privileges to create or modify a database on the target MySQL server there is an opportunity to save your data into a dump file.

Access2MySQL Pro converter fixes the contents of the source database into a local dump file instead of sending it to MySQL server directly. The destination file will consist of MySQL statements to create all tables and to fill them with the data. Using this dump file MySQL server administrator will add data to your MySQL database.

Features:

• Interactive (GUI) mode / command line mode;
• Ability to choose a particular number of tables to be converted.
• Saving data into a dump file, PHP script for export to MySQL database;
• Ability to use .sav file where all the settings of the program are stored when you run the program from command line;
• Support for MS Access Work Groups;
• Support for AutoIncrement (AutoNumber) fields conversion;
• Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MySQL internal purposes) with a substitute symbol.
• According to the MySQL restrictions, the dialog is shown up to force you to edit all incorrect table names. By default, each "garbage" symbol is replaced with '_' symbol.
• Support for field default values conversion;
• Automation of the conversion process with a built-in scheduler
• Ability to select ISAM, MYISAM, HEAP, InnoDB, BDB table types when copying data to MySQL or MySQL Text (dump file)
• High speed of data conversion. Access2MySQL Sync speed noticeably exceeds average showing in this category as the program works with direct access to MySQL server not through ODBC like other similar converters.

Important notices

• Does not convert system (hidden) tables.
• Does not convert relationships between tables.

Access2MySQL Sync is a data synchronization tool that presents bidirectional conversion (MS Access - MySQL) unlike other similar data migration tools, which commonly perform only one-way conversion.

In case you consider moving to MySQL after you convert your data from MS Access to MySQL server you can face the necessity to bring the data back to your Access base (e.g. it was modified by users of your MySQL db through Web Interface and you want to add this modified data to the MS Access database).

In case you don't want to convert all tables from a database, you can specify only those tables you would like to convert. There is opportunity to copy selected tables either in interactive mode (GUI) or launch the copying process through the command line.

You have an opportunity to run the conversion process un-attended on a user defined schedule. Built-in scheduler will launch Access2MySQL program without user input at a time that is most convenient for you.

Along with this general functionality, Access2MySQL Sync supports database synchronization to avoid the unnecessary data duplication.

Database synchronization:

Generally synchronization means the process of uploading and downloading information from two or more databases, so that each is identical. In view of MS Access to MySQL conversion synching can be defined as an operation that keeps distributed databases in agreement and normally refers to the routine updating of an MySQL database with information from an MS Access database and vice versa.

Access2MySQL Sync gives you an opportunity to update only the tables that have changed since the last sync without converting the whole database in order to minimize the amount of data that will have to go over the network. This synchronization feature is very useful when updating a database from another one or adding data from several source databases to only one destination database (special emphasis is laid on MS Access to MS Access synchronization).

• There is an option whether to copy identical records to a destination database or not
• Accurate external links handling when synchronizing from MS Access to MS Access

Features

• Database synchronization (Access - Access, Access - MySQL)
• Interactive (GUI) mode / command line mode;
• Ability to choose a particular number of tables to be converted.
• Support for MS Access Work Groups;
• Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MySQL internal purposes) with a substitute symbol.
• Support for AutoIncrement (AutoNumber) fields conversion;
• Ability to use .sav file when starting the program from command line;
• According to the MySQL restrictions, the dialog is shown up to force you to edit all incorrect table names. By default, each "garbage" symbol is replaced with '_' symbol.
• Support for field default values conversion;
• Automation of the conversion process with a built-in scheduler
• Ability to select ISAM, MYISAM, HEAP, InnoDB, BDB table types when copying data to MySQL
• High speed of data conversion. Access2MySQL Sync speed noticeably exceeds average showing in this category as the program works with direct access to MySQL server not through ODBC like other similar converters.

Requirements

• Windows 98/NT/Me/2000/XP/2003/ or later
• At least 32 MB of RAM
• Necessary privileges to write into database on the target MySQL server

Important notices

• Does not convert system (hidden) tables.
• Does not convert relationships between tables.