MySQL Workbench vs MySQL Migration Toolkit

MySQL is a very popular free cross-platform database management system. It is not surprising that a lot of organizations and companies move their databases from expensive propriate DMBS to MySQL. Most database professionals look for dedicated software to automate migration routines as those tasks are complicated and tedious when doing manually. MySQL Workbench is a solution from the famous database vendor to migrate miscellaneous DBMS to MySQL.

Benefits of MySQL Workbench:

  • It is compatible with all versions of MySQL and supports all the modern features of the DBMS
  • The product is free to download
  • SQL Server, Microsoft Access, Sybase ASE, PostgreSQL and some other popular DBMS are supported
  • Users can use the product to migrate databases from older MySQL versions to the latest
  • Very popular product among the MySQL community

Disadvantages of MySQL Workbench:

  • Requires ODBC drivers, Microsoft .NETFramework and Visual C++ Redistributableto run on MS Windows platforms
  • Only Microsoft Windows 10 or Windows Server 2019 are supported
  • Only one-way migration is supported
  • Does not migrate from Oracle

MySQL Migration Toolkit by Intelligent Converters is a collection of tools to migrate popular data sources to MySQL and vice versa. Unlike MySQL Workbench, this product does not use ODBC or any other middleware software. Low-level techniques of reading and writing data allow to achieve high performance and reliability of the database migration. Also, the product does not have multiple prerequisites and installation procedure only includes running setup executable.

Other features of MySQL Migration Toolkit:

  • All versions of MySQL servers are supported as well as forks (MariaDB, Percona) and SAAS variations
  • Wide range of supported platforms (Windows 7/8/10, Server 2012 and higher, Linux with WINE)
  • PostgreSQL, SQL Server, Oracle, SQLite, Firebird, IBM DB2, MS Access, MS Excel, DBF/FoxPro databases are supported
  • Tables, indexes, constraints and views are converted
  • Option to pre-process data via SELECT-queries before migration
  • Option to migrate into MySQL dump file for those cases when direct connection to MySQL server is not available
  • Option to serialize conversion settings into profile to simplify next run
  • Command line version of every tool allows to script and schedule the migration procedure

Disadvantages of MySQL Migration Toolkit

  • Does not migrate stored procedures, functions and triggers
  • Works with predefined DBMS (see above), universal ODBC layer is not supported

The price for MySQL Migration Toolkit starts from $99 that includes lifetime license, unlimited technical support service and 1 year subscription for updates. More information about the product can be found on the official page.

Leave a Reply

Your email address will not be published. Required fields are marked *

*