Technical Update for EDB Postgres Migration Portal 2.5.0

February 07, 2020

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


Technical Alert Details
EDB PostgresTM  Migration Portal  2.5.0

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

    would become
    CREATE TABLE tab (
         a NUMBER,
         d DATE

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.
 For more details, please review the EDB Postgres Migration Portal documentation:
 EDB Postgres Migration Portal Guide.

If you experience any problems installing the new software please contact Technical Support at:
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: 0008000503922
Share this

Relevant Blogs

More Blogs

New EDB Professional Services for Postgres

The demands are growing ever louder for the IT to become more agile and responsive to the business, but ensuring database implementations are correctly planned, implemented, managed and optimized is...
November 25, 2019