Access To MySQL Data Migration Tool

Access-MySQL 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.

Main features

-Supports MS Access 97, 2000, XP, 2003, 2007 and MySQL 3.x, 4.x and 5.x.

-All common MySQL and Access data types and field attributes are supported

-Full support for converting indexes, Auto increment fields, composite primary keys and Constraints.

-Support converting table relationships.

-The ability to select only the tables & fields which you want convert.

-You can choose which records to convert through custom data filetrs. New

-Supports both local and remote connections to MySQL server.

-Support convert all white spaces or any special characters you choose in MS Access Database tables or field names to underscores "_" or any other character (s), for example, Automatically convert "Order Details" table to "Order_Details".

-Command line support.

-Support for scheduling conversion tasks to be performed automatically.

-Support for Synchronization, Adding new records or fields if any to the target table, Access to MySQL only. Also support updating the same record values.

-New Support for saving MySQL connection data so you don't have to enter them each time you run the wizard.

-Support changing all field names case to UPPER, lower or Capitalize first letter only

-Support for converting NULL values to "Zeros" for numeric fields and to Empty string "" for string fields.

-Support to control how the data type for Access "datetime" fields are handled for each table, Convert it to Date, DateTime, Time or Year.

-Support to choose whether to convert Indexes or not.

-Support to choose target table type for MySQL. MyISAM, InnoDB, Heep, ISAM or BDB.

-Introduces a new feature called Task Manager to enable you to manage your saved conversion tasks