This article was originally published on September 16, 2020
WHAT’S NEW
This is to update you about the release of Migration Portal 2.10.0, the latest version of the web-based self-service tool for assessing and migrating Oracle database schemas to the EDB Suite. 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:
-
Branding updates
We’re thrilled to unveil our renewed brand identity, which has a lighter look and feel.
-
UI Changes
We made a few improvements to the UI and the data migration assessment report. Now when you download the PDF format report, the text doesn't merge and split on the next page.
Repair Handlers
-
Updated Repair Handlers
The following are the updated repair handlers. Repair handlers convert Oracle syntax to Postgres-compatible syntax so that you don’t have to do it manually.
-
ERH 1001 - REGEXP_LIKE_SYNTAX_ERROR
With this update, the repair handler fixes PL/SQL objects along with storage objects.
-
ERH 2037- TIMESTAMP_WITH_LOCAL_TIMEZONE_DATATYPE
Earlier the repair handler only fixed the TABLE object; now, all the objects will be fixed.
Fixed Customer Defects/Enhancements
-
TIMESTAMP WITH LOCAL TIME ZONE - we now convert all object data types for variable declarations inside functions, procedures, packages, and triggers. [MIG - 1628, Support Ticket 1011994]
TELL ME MORE
For more details, please review the Migration Portal documentation:
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