Access MySql Wizard

A tool that allows you to convert from MS Access to MySQL databases and vice versa.

Pros: This is an automation tool, designed for automating the process of converting databases from MS Access to MySQL format and vice versa. What makes it better than other tools of this kind is that it maintains Table relationships during the conversion process. If a user seeks more control over the conversion process, this is possible through a very fine grained control over the entire process: scheduling of tasks, field selection, renaming tables to what you consider to be more suitable, command line support for advanced users used to doing command line conversions with support for all standard options, and extended support for a wide range of character sets. A Task Manager allows you to view saved conversion tasks (conversion tasks with the specified tasks can be saved for later use). A set of data filters can be used to filter out and convert only those fields that are desired. Special characters can be selectively used for replacement when converting. When converting from MySQL to Access you can select the output database format (such as ’97, 2000, XP, or 2003). You can select MySQL 3.x, 4.x, and 5.x as output formats when converting from Access. It supports a number of output table formats including MySQL, MyISAM, InnoDB, Heep, ISAM and BDB. It supports the conversion of indexes, Auto Increment fields, composite primary keys and Constraints. You can choose to convert the table structure along with the data, or simply the table structure, which you can then use to store new data.

Cons: No significant limitations. The interface requires some prior understanding of databases and database terminology. That is understandable given the domain that it is targeted at.

Overall: 5 stars. A very good tool and seemed to do database conversions back and forth between MS Access and MySQL without any issues.

Access-MySQL Wizard is an automation tool that can convert any Access database to MySQL and vice versa ,it supports converting Table Relationships, the very essential feature that has always been missing in MySQL Converters world. Access-MySQL Converter, also provides you with a granular control over the conversion process like scheduling of conversion tasks •field selection • renaming of tables during conversion ,Command line support, Full support for different Character sets supported by MySQL 4.1 or higher • Ability to save conversion tasks for later use • Task Manager is a new feature that allows you to view and manage your saved conversion tasks • Data Filters is a very powerful feature that enables you to easily create custom data filters to convert only records that apply to those filters • Enhanced logging capabilities to keep track of conversion tasks • Enhanced Special characters support. You can select to replace any special characters either in database structure or the records with any characters you need • Enhanced Synchronization support. Access-MySQL Converter now can update existing records of the target database if the target table has any unique row identifiers (Primary keys or unique indexes) • Totally new and enhanced graphical user interface