Access-MySQL software allows for efficient conversion of data between Access and MySQL servers with advanced features including selective field and relationship conversions, and scheduling options.
Access-MySQL is a powerful tool designed for efficient data conversion from MS Access databases to MySQL server and vice versa. The software offers many advanced features, including the ability to select a specific number of tables from the source database, as well as a certain number of fields from each table. Furthermore, Access-MySQL can convert relationships between tables and support command line functionalities. The software also offers users the option to easily schedule conversion tasks to be performed automatically.
Some of the main features of Access-MySQL include support for MS Access 97,2000,XP, 2003, and MySQL 4.x, as well as successful testing against MySQL 5.0.0a-alpha. All common MySQL and Access data types and field attributes are supported. The software also allows for the conversion of table relationships and synchronization, ensuring that new records or fields added remain up-to-date.
Other notable features include the ability to select a target table type for MySQL, with supported types including MyISAM, InnoDB, Heap, ISAM, or BDB. Access-MySQL provides full support for the conversion of indexes, auto-increment fields, composite primary keys, and constraints. Users also have the flexibility to select only the tables and fields they wish to convert, and rename tables during conversion.
Access-MySQL supports changing "Date/Time" fields data type when converting from Access to MySQL, with supported data types including DateTime, Date, Time, and Year. The software also supports converting NULL values to "Zeros" for numeric fields and to an Empty string "" for text-based fields. Additionally, Access-MySQL provides command line support and allows users to change Access field character case in the target MySQL database.
Overall, Access-MySQL is a versatile and effective tool for data conversion between MS Access and MySQL databases. Its many features and flexible options make it an excellent choice for any user needing to convert and synchronize data between these two platforms.
Some of the main features of Access-MySQL include support for MS Access 97,2000,XP, 2003, and MySQL 4.x, as well as successful testing against MySQL 5.0.0a-alpha. All common MySQL and Access data types and field attributes are supported. The software also allows for the conversion of table relationships and synchronization, ensuring that new records or fields added remain up-to-date.
Other notable features include the ability to select a target table type for MySQL, with supported types including MyISAM, InnoDB, Heap, ISAM, or BDB. Access-MySQL provides full support for the conversion of indexes, auto-increment fields, composite primary keys, and constraints. Users also have the flexibility to select only the tables and fields they wish to convert, and rename tables during conversion.
Access-MySQL supports changing "Date/Time" fields data type when converting from Access to MySQL, with supported data types including DateTime, Date, Time, and Year. The software also supports converting NULL values to "Zeros" for numeric fields and to an Empty string "" for text-based fields. Additionally, Access-MySQL provides command line support and allows users to change Access field character case in the target MySQL database.
Overall, Access-MySQL is a versatile and effective tool for data conversion between MS Access and MySQL databases. Its many features and flexible options make it an excellent choice for any user needing to convert and synchronize data between these two platforms.
What's New
Version 2.5: Ability to convert relationships between tables , ability to select certain numbrr of fields from each table , and ability to rename tables during conversion