|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:
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.
- Enhanced filters on workspace page along with minor UI changes
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.
CREATE TABLE tab (
) PARTITION BY RANGE (d) INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) STORE IN (tbs1);
CREATE TABLE tab (
) PARTITION BY RANGE (d) INTERVAL (NUMTOYMINTERVAL(1,'MONTH'));
Following are the new knowledge base entries added:
TELL ME MORE
- 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