Access MySql Converter 3.0

Access MySql Converter 3.0 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 ,and many more advanced features .

Major Features:

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

2. All common MySQL and Access data types and field attributes are supported.

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

4. Support converting table relationships.

5. The ability to select only the tables you want convert.

6. The ability to select certain fields for each table to convert. 

7. You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database.

8. You can choose to convert both table structure and data or convert table structure only.

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

10. Supports both local and remote connections to MySQL server.

11. 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".

12. Command line support.

13. Support for scheduling conversion tasks to be performed automatically.

14. 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. 

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

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

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

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

19. Support to choose whether to convert Indexes or not.

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

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

Enhancements:

• Ability to convert relationships between tables
• Ability to select certain numbrr of fields from each table
• Ability to rename tables during conversion .