This article was originally published on May 19, 2023
WHAT’S NEW
This update is notifying you of the new software release of Migration Portal 4.5.0. Migration Portal is a web-based service for assessing and migrating Oracle database schemas to the EDB Postgres Advanced Server platform..
Highlights of this release include the following:
Enhancements
- The Migration Portal’s migration complexity and feature analysis capability has been enhanced to capture and report the presence of the following Oracle features that had previously not been captured:
- SELECT FOR UPDATE OF
- ANY with = <> != operators
- ANY with > < >= <= operators
- IS JSON CHECK CONSTRAINT
- LISTAGG ON OVERFLOW
- UNDER IN TYPE DEFINITION
- REF IN TYPE SPECIFICATIONS
- OVERRIDING SUBPROGRAM DECLARATION IN TYPE
- OF IN OBJECT VIEW CLAUSE
- The EDB DDL Extractor utility now provides the option to extract GRANT statements only if desired when extracting schemas. Previously, GRANT statements were always extracted. Now, users are given the choice to extract them. By default, GRANT statements are not extracted.
- The Migration Portal now indicates when a project is targeting an EDB Postgres Advanced Server database version that is nearing the end of normal support and to restrict further updates to the project when support for the target database is removed from the Migration Portal.
- Migration Portal now shows the project creation date and the Migration Portal version used when the project was created in the Overview section of the Migration Portal user interface.
- Migration Portal now detects the SQLERRM() function as an incompatible function for target EPAS database versions 11 to v14.
- Migration Portal has been enhanced with a new repair handler (ERH-2103), which replaces the use of the “= ANY” operator with “IN” and the “!= ANY” operator with “NOT IN”.
- Repair handler ERH-2100 now detects and removes WRITE ON DIRECTORY grant privileges, which aren't supported by EDB Postgres Advanced Server.
Security Fixes
- The ejs library (for Node.js) used by the Migration Portal has been updated to address the security vulnerabilities identified in CVE-2022-29078 and CVE-2021-23566.
- The terser (NPM) library used by the Migration Portal has been updated to address the security vulnerability identified in CVE-2022-25858.
Bug Fixes
- Fixed the issue where some unsupported system grants like IMPORT FULL and EXPORT FULL were not being removed by Migration Portal.
- Fixed the issue where the DBMS_UTILITY.FORMAT_CALL_STACK and DBMS_UTILITY.LNAME_ARRAY functions were incorrectly flagged as being incompatible although they are supported in EDB Postgres Advanced Server.
- Fixed the issue where the CREATE ROLE statement was not getting extracted for a role that is assigned to another role.
- Removed the unnecessary SET SEARCH_PATH=GLOBAL_OBJECTS statement from the project export sql file.
- Fixed the issue that was causing the Migration Portal assessment process to error out during the file parsing phase in a specific use case.
- Fixed the issue where nested tables that were being extracted and included in the uploaded source DDL by the Oracle Data Pump utilities was causing a parsing failure. EDB Postgres Advanced Server does not support nested tables. As a result, they are removed from the source DDL prior to processing and assessment by the Migration Portal.
TELL ME MORE
For more information about the latest version of Migration Portal, please see the Migration Portal 4.5.0 documentation.
END OF SUPPORT NOTICE
Since the end of standard support for EDB Postgres Advanced Server (EPAS) version 11 is scheduled for November 20, 2023, more recent versions of EPAS that will be supported beyond 2023 should be selected for new Migration Portal projects. Support for EPAS 11 is planned to be removed from the Migration Portal on May 20, 2023 to help ensure that no new EPAS 11 projects will be created after this date.
To maximize the length of available support and to take advantage of new features, particularly those that provide additional compatibility with Oracle, EDB recommends selecting the latest EPAS version as the target of a Migration Portal project. See the EDB Platform Compatibility page for more information on the support periods for each EDB Postgres Advanced Server major version.
TROUBLESHOOTING
If you experience any problems with the installation, migration, upgrade, or general use of your EDB software contact our Technical Support teams.
Customers can reach Technical Support through the EDB Customer Support Portal. We’re also available 24x7 via email and phone:
techsupport@enterprisedb.com
trial-help@enterprisedb.com
US: +1-732-331-1320 / 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612