MySQL Migration Toolkit v6.5

Released: Jun 9, 2017

v6.5 での更新項目

機能

Access-to-MySQL converter

  • Support for attachment type and column description.

DBF-to-MySQL converter

  • Improved support of FoxBase database format.
  • Options to specify MySQL table type and charset.

MSSQL-to-MySQL converter

  • Options to specify MySQL table type and charset.
  • Support for XML type and user-defined logfile in MSSQL-to-MySQL converter.

PostgreSQL-to-MySQL converter

  • Option to connect to non-default PostgreSQL database.
  • Options to specify MySQL table type and charset.
  • Verified support for Heroku.
  • Filter data via SELECT-queries.
  • Improved conversion of TIME type.
  • improved conversion of numeric types w/o precision.
  • Improved support of smallserial, serial and bigserial types.

MySQL-to-MSSQL converter

  • Improved conversion of veiws for 'export into t-sql script' scenario.
  • Support for curdate, curtime and date_format in views.
  • Reorder option for views to control order of conversion.
  • Use VARCHAR(MAX) and VARBINARY(MAX) instead of depricated TEXT and IMAGE.

MySQL-to-PostgreSQL converter

  • Option to connect to non-default PostgreSQL database.
  • Option to export MySQL database into PostgreSQL script file.
  • Verified support for Heroku.
  • Types customization: change type and name of any columns as well as exclude from conversion.
  • Option to make database objects names case sensitive.
  • Convert MySQL views in PostgreSQL format.

MySQL-to-Excel converter

  • Support for MS Excel 2007+ (xlsx) format.
  • Quick launch.

不具合の修正

MySQL-to-PostgreSQL converter

  • Fix: improved pure time support.
  • Fix: processing '0000-00-00' default values for date columns.