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));
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]
TROUBLESHOOTING If you experience any problems installing the new software please contact Technical Support at: Email: firstname.lastname@example.org Phone: US: +1-732-331-1320 or 1-800-235-5891 UK: +44-2033719820 Brazil: +55-2139581371 India: +91-20-66449612