EDB Technical Update for Migration Toolkit 53.0.0

Customer Portal
Customer Portal

This article was originally published on November 15, 2019

 
TECHNICAL UPDATE
EDB Migration Toolkit  53.0.0

WHAT’S NEW
This document provides information about what’s new and fixed customer defects in the EDB Migration Toolkit Ⓡ  53.0.0 product release. The tool migrates tables, views, procedures, functions, packages, and other database objects and data from SQL Server, Sybase, Oracle and MySQL to Postgres and EPAS.

Highlights of this release include:
  • Migration Toolkit now supports PostgreSQL EPAS 12 as the source and the target database.
  • Migration Toolkit supports the migration of the following Oracle features to EPAS 12:
    • Compound triggers
    • SYS_GUID
    • MEDIAN
    • LISTAGG
    • CAST_MULTISET
    • Interval Partition
    • SELECT UNIQUE
For more information, see EDB Postgres Advanced Server v12 Features.

The following customer defects are fixed in this release:
- MySQL 5.5  to EPAS 11 - end-of-copy marker corrupt issue. [MTK-170, Support Ticket #870755]
- MySQL 5.5  to EPAS 11- Invalid DataType LONGTEXT. [MTK-171, Support Ticket #870755]
- Oracle 10g to PPAS 9.5 - Issue with AUTHID while migrating the procedures. [MTK 172, Support Ticket  #746013]
- SQL Server to PG 9.6 - Migration from SQL Server to PG 9.6 fails with error "Invalid object name information_schema.tables". [MTK 175, Support Ticket #866046]
- Oracle 11g to EPAS 12 - “-replaceNullChar" is not working for CLOB data types. [MTK-176, Support Ticket #862264]
-  Need to update “-replaceNullChar” parameter related details in the document for more clarification. [MTK-177, Support Ticket #862264]
- Oracle 12c to EPAS 11 - Issue with "-useOraCase" option of MTK. [MTK-214, Support Ticket #917400]
-  Documentation update for “-replaceNullChar”. [MTK-218, Support Ticket #903098]

IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Migration Toolkit 53.0.0 and have a database subscription purchased for:
  • EDB Postgres Standard Edition
  • EDB Postgres Enterprise Edition
HOW TO GET THE SOFTWARE
This update is available from the EDB Postgres downloads website (https://www.enterprisedb.com/downloads/edb-migration-toolkit) or via Stack Builder Plus for Windows.

This update is also available as an RPM package that can be downloaded from the yum.enterprisedb.com repository.

Native packages are also available for Debian 9 and Ubuntu 18 hosts.  To request the credentials required to access EnterpriseDB repositories, please visit https://www.enterprisedb.com/repository-access-request

For more information, see the EDB Postgres Migration Toolkit Guide.

TROUBLESHOOTING
If you experience any problems installing 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

Was this article helpful?

0 out of 0 found this helpful