ACCESS MYSQL CONVERTER 3.0

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. Main Features: 1) Supports MS Access 97,2000,XP, 2003 and MySQL 4.x, also tested successfully against MySQL 5.0.0a-alpha . 2) All common MySQL and Access data types and field attributes are supported. · 3)Task Manager allows you to view and manage your saved conversion tasks. 4) 4)Data Filters that enables you to easily create custom data filters to convert only records that apply to those filters. 5) Convert Table Relationships. 6) 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. · 7) Support for scheduling of conversion tasks to be performed automatically. 6) Support to choose target table type for MySQL. MyISAM, InnoDB, Heep, ISAM or BDB table types are supported. 8) Full support for converting indexes, Auto increment fields, composite primary keys and constraints. 9) The ability to select only the tables you want to convert. 10) The ability to select only the fields you want to convert for each selected table. 11) Support for Renaming Tables during conversion . 12 Support for converting NULL values to "Zeros" for numeric fields and to Empty string "" for text-based fields. · 13) Support for changing "Date/Time" fields data type when converting from Access to MySQL. "DateTime","Date","Time" and "Year" data types are supported. 14) Command line support . · 15) Support for change Access fields character case in the target MySQL database.

Main features

Supports MS Access 97,2000,XP, 2003 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 you want convert.
The ability to select certain fields for each table to convert. New
You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database.
You can choose to convert both table structure and data or convert table structure only.
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. New