Access-MySQL is a versatile and efficient software for converting between Access and MySQL databases. It offers advanced features such as choosing specific fields, converting table relationships, and scheduling.
Access-MySQL is a data conversion tool perfect for those who want to transfer their MS Access databases to MySQL servers and vice versa. It’s an efficient software that supports various advanced features. You can select a specific number of tables from the source database and choose a certain number of fields from each table. It also allows you to convert relationships between tables, offers command line support and scheduling of conversion tasks to be done automatically.
This software has a lot to offer, making it a popular choice in the market. Some of its most notable features include support for MS Access 97, 2000, XP, 2003 and MySQL 4.x, and successful testing against the MySQL 5.0.0a-alpha. It also supports all common MySQL and Access data types and field attributes.
Another feature is the Task Manager, which enables you to view and manage your saved conversion tasks. You can create custom data filters to convert only records that are relevant to those filters with the help of the Data Filters feature.
Access-MySQL also supports Synchronization, adding new records or fields to the target database. You can choose the target table type for MySQL by selecting MyISAM, InnoDB, Heep, ISAM or BDB table types. It supports converting indexes, Auto increment fields, composite primary keys and constraints.
The software also allows you to select only the tables you want to convert and the fields you want to convert for each selected table. Renaming Tables during conversion is also achievable. The software supports converting NULL values to "Zeros" for numeric fields and to an Empty string "" for text-based fields.
Support for changing "Date/Time" fields data type when converting from Access to MySQL is another feature. "DateTime", "Date", "Time" and "Year" data types can be supported. Access-MySQL also has command line support and supports changing Access fields character case in the target MySQL database.
This software has a lot to offer, making it a popular choice in the market. Some of its most notable features include support for MS Access 97, 2000, XP, 2003 and MySQL 4.x, and successful testing against the MySQL 5.0.0a-alpha. It also supports all common MySQL and Access data types and field attributes.
Another feature is the Task Manager, which enables you to view and manage your saved conversion tasks. You can create custom data filters to convert only records that are relevant to those filters with the help of the Data Filters feature.
Access-MySQL also supports Synchronization, adding new records or fields to the target database. You can choose the target table type for MySQL by selecting MyISAM, InnoDB, Heep, ISAM or BDB table types. It supports converting indexes, Auto increment fields, composite primary keys and constraints.
The software also allows you to select only the tables you want to convert and the fields you want to convert for each selected table. Renaming Tables during conversion is also achievable. The software supports converting NULL values to "Zeros" for numeric fields and to an Empty string "" for text-based fields.
Support for changing "Date/Time" fields data type when converting from Access to MySQL is another feature. "DateTime", "Date", "Time" and "Year" data types can be supported. Access-MySQL also has command line support and supports changing Access fields character case in the target MySQL database.
What's New
Version 3.0: Ability to convert relationships between tables , ability to select certain numbrr of fields from each table , and ability to rename . tables during conversion .