This article was originally published on December 08, 2022
WHAT’S NEW
This update is notifying you of the new software release of Migration Portal 4.3.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 has been enhanced to support the assessment and migration of users, roles, profiles and grants from the source Oracle database.
- The Migration Portal has been updated to provide links to the new version of the EDB DDL Extractor that provides support for extracting users, roles, profiles and grants. The Migration Portal is still able to process and assess DDL generated by the older version of the EDB DDL Extractor; however, the newly supported user related information will not be extracted by those older versions.
- The Migration Portal schema migration complexity scoring and feature analysis capability has been enhanced to provide a score and feature analysis that is based on the selected target EDB Postgres Advanced Server version and not only on version 14 as was the case in the prior releases.
- The Migration Portal user interface for migrating schemas to a target database has been simplified to enable offline and online migration modes with a reduced number of steps and redundant options.
- The Migration Portal migration complexity and feature analysis capability has been enhanced to capture and report the presence of Oracle features that had previously not been being captured, including the following features:
- CONNECT BY CONDITION
- CONNECT BY NOCYCLE
- Built-in/SYS owned Function GROUP_ID
Security Fixes
- The jackson-databind library used by the Migration Portal has been updated to address the security vulnerabilities identified in CVE-2022-42003 and CVE-2022-42004.
Bug Fixes
- Fixed the handling of MAXVALUE for sequences to avoid warnings and also to resolve the issue with the maximum value allowed for MAXVALUE supported in the target EDB Postgres Advanced Server database.
- Fixed an issue in the handling of ALTER TABLE MODIFY statements related to virtual table columns that are found in the extracted DDL generated using Oracle Data Pump utility.
- Fixed an issue where the PIPELINED clause feature is not reported when the clause is used within a package function definition.
- Fixed an issue related to catalog views not being detected and reported in compatible features in certain cases.
TELL ME MORE
For more information about the latest version of Migration Portal, please see the Migration Portal 4.3.0 documentation.
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