| 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.
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: 0008000503922 |
|
