Release Announcement Migration Portal 4.0.0

Type

Highlights

Enhancement

The Migration Portal now supports the use of the EDB DDL Extractor again. Issues related to the DDL Extractor are resolved and the temporary restriction introduced on the use of DDL Extractor file format has been removed. The Migration Portal continues to support the use of the Oracle Data Pump utilities following the instructions in the documentation; however, the use of the EDB DDL Extractor is recommended.

Enhancement

The schema assessment algorithms have been optimized to address a few performance related issues and to reduce overall schema assessment time.

Enhancement

Added repair handler to remove CACHE/NOCACHE keyword from TABLE definition as EDB Postgres Advanced Server does not support it.

Security Fix

The jackson-databind and h2 libraries have been upgraded to the latest versions to address security issues (CVE-2020-36518, CVE-2022-23221, CVE-2021-42392 and CVE-2021-23463).

Bug Fix

Fixed the grammar rule to resolve a parsing error that skipped execution of a repair handler to remove EDITIONABLE keywords.

Bug Fix

Fixed the repair handler to perform proper conversion of Oracle PIPELINED and PIPE ROW function calls.

Bug Fix

Fixed an issue where case sensitivity was lost when an object name was based on Unicode characters.

Bug Fix

Fixed the issue that displays the Getting Started wizard when Migration Portal landing page is opened for the first time for a new user.

Bug Fix

Fixed the issue where a  VIEW definition was truncated during transformation in the target EPAS DDL script. 

Bug Fix

Previously, uploaded DDL files having characters that were not compatible with UTF-8 were failing at the start of the Assessment phase. Migration Portal now reads the SQL files as UTF-8. In case a non UTF-8 file is uploaded, all the characters that are not compatible with UTF-8  will be converted to the replacement character ‘�’ and assessment will continue without failing.

Bug Fix

Fixed constraint name assignment for the unnamed constraint in the source Oracle DDL.

Bug Fix

Updated the repair handler to remove the OIDINDEX storage clause for Oracle Data Pump generated source DDL files.

Bug Fix

Allowed the COLLATE and COMPUTATION keywords to be used as identifiers.

Bug Fix

Fixed the handling of multi-line comments that appear as part of single line comments.

Bug Fix

Fixed the grammar to properly identify and skip wrapped objects.

Bug Fix

Fixed ConcurrentModificationException occurred while running multiple projects simultaneously.

Bug Fix

Fixed unique object names handling across multiple schemas. The object names are not required to be unique across different schemas.

Bug Fix

Made some fixes in the create table grammar to ignore the order of some clauses as no specific order is required.