cancel
Showing results for 
Search instead for 
Did you mean: 

Technical Update for EDB Migration PortalⓇ 2.2.

Technical Alert/Update Information

Technical Alert Name
EDB Technical Update for Migration PortalⓇ 2.2.0
Product Type
EDB Postgres Migration Portal
Release Date
9/6/2019
Technical Alert Details
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.

    User-added image

     
  • Manually repaired object details
    You can now filter the system repaired and manual repaired objects on the Workspace page.

    User-added image
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
Version history
Revision #:
1 of 1
Last update:
a week ago
Updated by:
 
Contributors