Version 4.0 v4
New features, enhancements, bug fixes, and other changes in Migration Portal 4.0 include the following:
| Type | Description |
|---|---|
| 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 are optimized to address a few performance related issues and to reduce overall schema assessment time. |
| Enhancement | Added a 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 are 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 the 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. |