This article was originally published on April 30, 2021
WHAT’S NEW
This is to update you about the release of Migration Toolkit 54.0.1. The tool migrates tables, views, procedures, functions, packages, and other database objects and data from SQL Server, Sybase, Oracle, and MySQL to PostgreSQL and EDB Postgres Advanced (EPAS).
Highlights of this release include:
- The following customer defects are fixed in this release:
|
Support Ticket |
Description |
|
936807 |
Migration issue with the resource parameter INACTIVE_ACCOUNT_TIME for profiles |
|
1051412 |
MTK creating two unique indexes on the target database when the source is using “USING INDEX” clause |
|
1129386 |
MTK memory leaks while extracting BINARY XMLTYPE data from Oracle |
|
1129481 |
Encountering parsing errors with objects having PostgreSQL keywords in its name for MySQL to Postgres migration |
|
1162550 |
runMTK.sh -help missing description of -lobBatchSize option |
|
1129481 |
MySQL JDBC driver returns BIT datatype for TINYINT columns and MTK using the same as a column datatype, resulting in migration error. |
|
1056630 |
Unable to migrate tables with datatype BLOB from Oracle to EPAS for -useOraCase option |
|
1247865 |
Error for “all_tab_partitions” usage for EPAS in PG Mode |
|
1250135 |
Performance issue with MTK 54.0.0 because of MIG-2549 |
IS THIS FOR ME?
This announcement is for EDB customers who are using – or are interested in – Migration Toolkit 54.0.1 and have a database subscription purchased for:
- EDB Postgres Advanced 13, 12, 11, 10, and 9.6
- PostgreSQL 13, 12, 11, 10, and 9.6
HOW TO GET THE SOFTWARE
Migration Toolkit v54.0.1 is packaged and delivered as a series of interactive installers available via Stackbuilder Plus and on the EDB website. Visit:
https://www.enterprisedb.com/advanced-downloads
This update is also available as native packages in the form of RPMs and DEBs. Visit:
https://repos.enterprisedb.com/
To request the credentials required to access EDB repositories. Visit: https://www.enterprisedb.com/repository-access-request
Documentation is provided on the EDB website. Visit: https://www.enterprisedb.com/edb-docs/p/edb-postgres-migration-toolkit
TROUBLESHOOTING
If you experience any problems installing https://www.enterprisedb.com/edb-docs/ the new software, please contact Technical Support at:
Email: support@enterprisedb.com
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612