EDB Technical Update for Migration PortalⓇ 2.2.0

TECHNICAL UPDATE
EDB Migration Portal^Ⓡ  2.2.0

WHAT’S NEW
This update is notifying you of a new software release EDB Migration Portal 2.2.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 include:

• Enhanced EDB DDL Extractor
  You can now choose to extract the dependent objects while extracting the schemas. So, the dependent objects from the other schemas will also get extracted which will help in improving the assessment results.
• Enhanced onboarding experience
  Enhanced Getting Started experience for the new users.
• Add Index Prefix

As Advanced Server does not support the same name for tables and indexes, you may now choose to add an index prefix, ‘idx’, while creating a project for better assessment results.

• Assessment Report shows repair handlers counts
  The assessment report shows the count of distinct repair handlers applied to the DDLs under the selected schemas.
  
  
  
   
• Manually repaired object details
  You can now filter the system repaired and manual repaired objects on the Workspace page.
  
  

Note: Starting this release, Migration Portal will accept DDLs extracted by latest EDB DDL Extractor only.

New Repair Handlers

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

• ERH 2073 - Removes CONSTRAINT constraint_name NOT NULL DISABLE clause from the source DDL for tables.
  For example, CREATE TABLE TEST (COL1 VARCHAR2(40) CONSTRAINT TEST_COL1_NN NOT NULL DISABLE); would become CREATE TABLE TEST (COL1 VARCHAR2(40));
   
• ERH 2074 - Removes NOT NULL DISABLE clause from the source DDL for tables.
  For example, CREATE TABLE TEST(COL1 VARCHAR2(40) NOT NULL DISABLE ); would become CREATE TABLE TEST (COL1 VARCHAR2(40));
   
• ERH 2075 - Removes CONSTRAINT constraint_name CHECK|UNIQUE|PRIMARY KEY parameters DISABLE clause from the source DDL for tables.
  For example, CREATE TABLE TEST(DATE_COL1 DATE, CONSTRAINT TEST_DATE_COL1_CHK CHECK (DATE_COL1 > '01-JAN-2018') DISABLE); would become CREATE TABLE TEST (DATE_COL1 DATE);
   
• ERH 2076 - Removes CHECK|UNIQUE|PRIMARY KEY parameters DISABLE clause from the source DDL for tables.
  For example, CREATE TABLE TEST (ID VARCHAR2(40), PRIMARY KEY (ID) DISABLE); would become CREATE TABLE TEST (ID VARCHAR2(40));

Knowledge Base

Following is the new knowledge base entry added:

• NVL function inside Index definition
  In Advanced Server, DATE datatype from Oracle is converted into timestamp without time zone datatype for compatibility. However, in Advanced Server v10, the nvl() function does not support timestamp without time zone datatype in arguments.
  Following data types are supported in input argument for nvl() function in Advanced Server v10 :
  character varying
  Numeric
  Date
  timestamp with time zone
  Any other datatype used as input for nvl() function inside index definition will give an error.

Fixed Customer Defects

• Inconsistent object validity - ANTLR grammar is not able to recognize Postgresql's CREATE FUNCTION syntax correctly. [NGMTK 943, Support Ticket 896248]
   
• EDB Migration Portal Stuck at 0% [NGMTK 846, Support Ticket 875331]
   
• As a designer, List manually and automatically modified objects under the repaired tab with Migration portal [NGMTK 840, Support Ticket 879085]
   
• Show the count of distinct repair handlers applied on DDLs under that schema (for which report is generated) [NGMTK 816, Support Ticket 879158]

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