Access MySql description
Access-MySQL is an effective tool to convert Access to MySQL and vice versa

Access-MySQL is an effective tool for data conversion from MS Access databases to MySQL server and vice versa, supporting many advanced features like, the ability to select certain number of tables from the source database and moreover there is an ability to select certain number of fields from each table, converting relationships between tables, command line support, and scheduling of the conversion tasks to be performed automatically.

Here are some key features of "Access MySql":

· Supports MS Access 97, 2000, XP, 2003 and MySQL 4.x, also tested successfully against MySQL 5.0.0a-alpha.
· All common MySQL and Access data types and field attributes are supported.
· Convert Table Relationships.
· Support for Synchronization , Adding new records or fields if any to the target database. This keeps your source and target databases coherent and up-to-date
· Support for scheduling of conversion tasks to be performed automatically.
· Support to choose target table type for MySQL. MyISAM, InnoDB, Heep, ISAM or BDB table types are supported.
· Full support for converting indexes, Auto increment fields, composite primary keys and constraints.
· The ability to select only the tables you want to convert.
· The ability to select only the fields you want to convert for each selected table.
· Support for Renaming Tables during conversion .
· Support for converting NULL values to "Zeros" for numeric fields and to Empty string "" for text-based fields.
· Support for changing "Date/Time" fields data type when converting from Access to MySQL. "DateTime","Date","Time" and "Year" data types are supported.
· Command line support
· Support for change Access fields character case in the target MySQL database.


What's New in This Release:

· Ability to convert relationships between tables, ability to select certain number of fields from each table, and ability to rename tables during conversion


Limitations:

· Using the Demo Version you can convert only five tables, five records for each, in any Access database to MySQL Database or Vice versa., the tables which you can convert using the demo version is the top five tables appears in the available tables list in selecting tables step.