Access To MySQL Data Migration Tool 3.1
ccess-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