cancel
Showing results for 
Search instead for 
Did you mean: 

Technical Update for EDB Postgres Migration Portal 2.5.0

Technical Alert/Update Information

Technical Alert Name
EDB Technical Update for PostgresTM Migration Portal 2.5.0
Product Type
EDB Postgres Migration Portal
Release Date
2/7/2020
Technical Alert Details
TECHNICAL UPDATE
EDB PostgresTM  Migration Portal  2.5.0

WHAT’S NEW
This update is notifying you of a new software release EDB PostgresTM Migration Portal 2.5.0. EDB Postgres™ Migration Portal (Migration Portal) is a web-based self-service tool for assessing and migrating Oracle database schemas to the EDB Postgres platform. The Migration Portal assesses and analyzes Oracle database schemas and converts types, tables, sequences, constraints, triggers, views, stored procedures, packages, dblinks, materialized views, and indexes, producing DDLs that are compatible with EDB Postgres Advanced Server.

Highlights of this release:
  • Enhanced filters on workspace page along with minor UI changes
With the new filters, you can select one or more filter combinations to refine the information. Also, few minor changes are made to the new UI for better user experience.         

This image is not available because: You don’t have the privileges to see it, or it has been removed from the system

 

New Repair Handler

 

Following is the new repair handler added to improve the Advanced Server compatibility ratio:
  • ERH 2086 - Removes STORE IN (tablespace) clause from PARTITIONED TABLE having PARTITION BY HASH or PARTITION BY RANGE syntax.
    For example,
    CREATE TABLE tab (
         a NUMBER,
         d DATE
    ) PARTITION BY RANGE (d) INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) STORE IN (tbs1);

    would become
    CREATE TABLE tab (
         a NUMBER,
         d DATE
    ) PARTITION BY RANGE (d) INTERVAL (NUMTOYMINTERVAL(1,'MONTH'));

Knowledge Base

Following are the new knowledge base entries added:
  • Compound Triggers
    Oracle’s compound triggers are supported in Advanced Server from version 12 onwards. To make it work on earlier versions of Advanced Server, some workaround is required.
     
  • Explicit Casting
    Oracle implicitly casts CHARACTER data type to NUMBER when an expression or a numeric value passed is of type CHARACTER. However, in Advanced Server, you need to explicitly typecast the expression to a relevant data type.
     
  • XMLAGG function
    Oracle uses the XMLAGG function to concatenate multiple row values of a column into a single row. However, in Advanced Server, the STRING_AGG function is used instead of the XMLAGG function.
  • Update Subquery
    Oracle supports subquery in the UPDATE statement. However, in Advanced Server, Common Table Expression is used to support subquery in the UPDATE statement.
 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
Version history
Revision #:
2 of 2
Last update:
‎02-07-2020 10:31 AM
Updated by:
 
Labels (1)
Contributors