EDB Technical Update for Migration PortalⓇ  2.3.0

TECHNICAL UPDATE
EDB Migration Portal^Ⓡ  2.3.0

WHAT’S NEW
This update is notifying you of a new software release EDB Migration Portal 2.3.0. EDB Postgres™ Migration Portal (Migration Portal) is a web-based self-service tool for 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:

• Minor UI changes

Few minor changes are made in the new UI for better user experience.

New Repair Handlers

Following are the new repair handlers added to improve the Advanced Server compatibility ratio:

• ERH 2077 - Removes USING INDEX REVERSE clause from CREATE TABLE statement.
  For example, CREATE TABLE TAB1(ID INT, CONSTRAINT PK_ID PRIMARY KEY(ID) USING INDEX REVERSE); would become CREATE TABLE TAB1(ID INT, CONSTRAINT PK_ID PRIMARY KEY(ID));
   
• ERH 2078 - Converts PIPELINED clause in packaged pipelined functions to SETOF RECORD.
  For example, CREATE OR REPLACE EDITIONABLE PACKAGE MSCH.MPKG IS FUNCTION m_fn(p_2 IN VARCHAR2) RETURN m_typ_tab_t PIPELINED;END; would become CREATE OR REPLACE PACKAGE MSCH.MPKG IS FUNCTION m_fn(p_2 IN VARCHAR2) RETURN SETOF RECORD; END;
   
• ERH 2079 - Converts GLOBAL PARTITIONED index to LOCAL index.
  For example, CREATE INDEX s1.i1 ON s1.t1 (a) GLOBAL PARTITION BY HASH (a) (PARTITION "Q1" , PARTITION "Q2"); would become CREATE INDEX s1.i1 ON s1.t1 (a) LOCAL (PARTITION "Q1" , PARTITION "Q2");

Knowledge Base

Following are the new knowledge base entries added:

• Empty string as a default value for Numeric Datatype:
  Oracle allows empty string ('') as a default value for numeric data type columns. However,  Advanced Server does not allow empty strings as a default value for numeric data type columns.
• TO_DATE function with different datatype arguments
  Oracle allows the first parameter as a date data type in the to_date function. However, in Advanced Server both parameters must be of data type text (i.e. to_date(text, text)).
• ROUND function with different datatype arguments
  In Oracle, both parameters are of numeric data type for the ROUND function. However, in Advanced Server the first parameter is of numeric data type and the second is of the integer data type.

Fixed Customer Defects

• CREATE TABLE, if comes as part of comments, is captured as a valid DDL in MP. [NGMTK 902, Support Ticket 907110]
• Handling NOKEEP keyword in sequence in table definition [NGMTK 985, Support Ticket 901680]
• Round function Incompatible expression issue [NGMTK 992, Support Ticket 919531]

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