WHAT’S NEW This update is notifying you of a new software release EDB PostgresTMMigration 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.
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'));
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.
TROUBLESHOOTING If you experience any problems installing the new software please contact Technical Support at: Email: email@example.com Phone: US: +1-732-331-1320 or 1-800-235-5891 UK: +44-2033719820 Brazil: +55-2139581371 India: +91-20-66449612