This article was originally published on November 04, 2021
Release Announcement
Migration Portal 3.4.0
WHAT’S NEW
This is to update you about the release of Migration Portal 3.4.0, the latest version of the web-based, self-service tool for assessing and migrating Oracle database schemas to EDB Postgres Advanced Server. You can conveniently and quickly evaluate the feasibility of migrating one or multiple database schemas from Oracle to EDB Postgres Advanced Server, minimizing the time and risk typically involved with database migrations.
Highlights of this release:
|
Type |
Highlights |
|
Feature |
Added option to migrate schemas to EDB Postgres Advanced Server clusters on BigAnimal, the cloud platform powered by EDB. |
|
Feature |
Added repair handler to remove the 'ALTER TRIGGER <triggerName> ENABLE' statements or transform 'ALTER TRIGGER <triggerName> DISABLE' to EDB Postgres Advanced Server compatible syntax. (ERH-3001: ALTER_TRIGGER) |
|
Feature |
Added repair handler to add 'AS' for EDB Postgres Advanced Server reserved keyword ‘CASE’ when used as an alias in CASE Expressions. (ERH-1014: CASE_STATEMENT_ALIAS) |
|
Feature |
Added a Knowledge Base article to provide a workaround for Type inheritance. |
|
Feature |
Added Knowledge Base article for Oracle's 'AFTER ALTER ON SCHEMA' trigger using EDB Postgres Advanced Server's Event triggers. |
|
Feature |
Added Knowledge Base article for Oracle's feature in which a FUNCTION can use JAVA class using EDB Postgres Advanced Server's PL/JAVA extension. (This is applicable for EDB Postgres Advanced Server versions 10 and 11 only) |
|
Enhancement |
Added support for assessing larger DDL files (up to 1 GB size). |
|
Enhancement |
Removed the following Knowledge Base articles as Migration Portal now automatically repairs the incompatibilities associated with these:
|
|
Enhancement |
Enhanced the DDL extractor to find and list empty schemas. |
|
Enhancement |
Enhanced UI for a better user experience. |
|
Enhancement |
Optimized the object tree and common failure tree. |
|
Enhancement |
Enhanced repair handler to transform BFILE datatype to TEXT datatype in PL/SQL objects as well. (ERH-2039: BFILE_DATA_TYPE) |
|
Enhancement |
Enhanced repair handler to transform PARALLEL_ENABLE to PARALLEL SAFE for PACKAGE BODY and FUNCTION and remove PARALLEL_ENABLE keyword from PACKAGE SPECIFICATION. (ERH-2049: PARALLEL_ENABLE_FUNCTIONS) |
|
Enhancement |
DDL Extractor displays a warning message if the source Oracle version is not supported. |
|
Security Fix |
Addressed security/compliance findings against possible vulnerabilities. |
TELL ME MORE
For more details, please review the Release Notes.
TROUBLESHOOTING
If you experience any problems around the installation, migration, upgrade or general use of your EDB software, please contact our Technical Support teams. Customers may reach us at https://techsupport.enterprisedb.com, and we're also available 24x7 via email and phone at the details below:
Customer Email: techsupport@enterprisedb.com
Trial Use Assistance: trial-help@enterprisedb.com
Phone:
US +1-732-331-1320 / 1-800-235-5891
UK +44-2033719820
Brazil +55-2139581371
India +91-20-66449612