This article was originally published on June 11, 2020
WHAT’S NEW
This is to update you about the release of EDB PostgresTM Migration Portal 2.8.0, the latest version of the web-based self-service tool for assessing and migrating Oracle database schemas to the EDB Postgres Platform. You can quickly and conveniently evaluate the feasibility of migrating one or multiple database schemas from Oracle to Postgres, minimizing the time and risk typically involved with database migrations.
Highlights of this release:
* Compatibility gauge color
The Project Compatibility gauge is color-coded to display which projects are the most compatible in a single glance. You can either fix the projects manually that are not fully compatible or can contact an EDB representative for help.
-- Green indicates 100% compatible
-- Blue indicates 31% to 99% compatible
-- Red indicates 0% to 30% compatible
* Prepopulated email for migration services:
If there are any issues while assessing the schemas, you can contact the EDB representative for help. You can click the migrating services email ID in the message box. A draft from the system’s default email client will open with a prepopulated subject and body, saves your time drafting the request.
* Updated FAQ page:
The FAQ page is updated with the latest frequently asked questions.
Following is the FAQ link:
https://www.enterprisedb.com/migration-portal-faqs
* Enhanced User Experience: Many changes were made to the new UI to help you navigate through the portal more easily.
Repair Handlers
* New Repair Handler
Following is the new repair handler added to improve the Advanced Server compatibility ratio:
* ERH 1012 - Insert Statement Alias:
Removes alias name and the references of the alias name from the INSERT statement inside any PL/SQL block.
For example,
CREATE OR REPLACE PROCEDURE REMOVE_ALIAS_TEST (IN_PARAM VARCHAR2)
IS
V_VAR NUMBER (12, 0);
BEGIN
INSERT INTO TABLE_NAME ALIAS_NAME (ALIAS_NAME.ID,
ALIAS_NAME.NAME)
VALUES (1,
'test');
END;
would become;
CREATE OR REPLACE PROCEDURE REMOVE_ALIAS_TEST (IN_PARAM VARCHAR2)
IS
V_VAR NUMBER (12, 0);
BEGIN
INSERT INTO TABLE_NAME (ALIAS_NAME.ID,
NAME)
VALUES (1,
'test');
END;
Knowledge Base
Knowledge base entries provide workarounds or solutions for the objects that fail during an assessment. You can view and apply the knowledge base solutions to reassess the fail objects.
* New Knowledge Base entry
Following is the new knowledge base entry added:
* UTL_I18N.STRING_TO_RAW and UTL_I18N.RAW_TO_CHAR Package functions
In Oracle, UTL_I18N.STRING_TO_RAW function is used to convert VARCHAR2 or NVARCHAR2 string to another character set and returns the result as RAW data and UTL_I18N.RAW_TO_CHAR function is used to convert RAW data that is not encoded in the database character set into a VARCHAR2 string.
However, in Advanced Server encode and decode functions are used to convert VARCHAR2 or NVARCHAR2 string to RAW data and vice-versa.
TELL ME MORE
For more details, please review the EDB Postgres Migration Portal documentation:
EDB Postgres Migration Portal Guide.
TROUBLESHOOTING
If you experience any problems installing the new software please contact Technical Support at:
Email: support@enterprisedb.com
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612