MySQL has long been a preferred database management system (DBMS) for its extensive transactional support, flexibility of open-source software, and on-demand scalability. However, despite these advantages, many organizations still rely on commercial DBMS with much higher total cost of ownership than MySQL. Intelligent Converters, a software vendor specializing in database migration since 2001, has developed a dedicated solution called MySQL Migration Toolkit to help organizations migrate their databases to MySQL.
MySQL Migration Toolkit is a comprehensive collection of migration tools that can migrate data from MS Access, IBM DB2, Firebird, FoxPro, MS Excel, SQL Server, PostgreSQL, Oracle, SQLite to MySQL and backward. The product is known for its high performance, as it does not use ODBC or any other middleware components. Each conversion tool included in this software pack uses low level APIs for reading and writing data, with an average speed of the migration being about 20000 rows per second on an average modern hardware.
The product supports command line support to script, automate and schedule the migration process. Option to store conversion settings into profile makes recurrent database migration even more comfortable. Both on-premises and cloud variations of MySQL DBMS are supported, making it easy for organizations to choose their preferred deployment option.
MySQL Migration Toolkit allows users to convert data into a local MySQL dump file instead of moving it to MySQL server directly. This approach is known as indirect conversion, and it is designed to provide users with more control over the process. It also can be used when remote connection to MySQL server is not available: the script file is transferred to database server over FTP and then database specialist imports it to MySQL database via the standard tools like phpMyAdmin. The resulting script file contains MySQL statements to create all tables and to fill them with the data.
The product migrates table definitions with all necessary attributes, such as null flag and default values. It also migrates data, indexes, constraints, and most views (except syntax patterns having no direct equivalent in the target DBMS). When migrating a database to MySQL, the product allows users to specify the table type (ISAM, MyISAM, HEAP, InnoDB, or BDB) and character set. Custom column mapping allows users to change the name, type, default value, and NULL-attribute for any column of the resulting table.
MySQL Migration Toolkit supports all versions of MySQL, including such forks as MariaDB and Percona. It also offers an option to merge and synchronize the target database with the source data, ensuring that data is always up to date. The product supports Unicode, making it easy to migrate data in any language.
Finally, MySQL Migration Toolkit comes with an intuitive wizard-style interface that makes it easy to use for both novice and advanced users. More information about MySQL Migration Toolkit can be found on the official website of Intelligent Converters. With this powerful tool, organizations can migrate their databases to MySQL easily and cost-effectively, without sacrificing performance or flexibility.