EDB Technical Update for Migration PortalⓇ 2.1.0

TECHNICAL UPDATE
EDB Migration Portal^Ⓡ  2.1.0

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

• Minor UI changes

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

• Old UI will not be available
  Starting this release, old UI will not be available.

New Repair Handlers
The following repair handlers are added to improve the Advance Server compatibility ratio:
 

• ERH 2065 - Removes the NO INMEMORY clause from the source DDL.
  For example, CREATE TABLE tab(a INTEGER) NO INMEMORY; would become CREATE TABLE tab(a INTEGER);
   
• ERH 2066 - Removes RELY from the PRIMARY KEY CONSTRAINT clause in CREATE TABLE Statement.
  For example, CREATE TABLE t(a INT, CONSTRAINT c PRIMARY KEY(a) RELY); would become CREATE TABLE t(a INT, CONSTRAINT c PRIMARY KEY(a));
   
• ERH 2067 - Removes RELY from the REFERENCES clause of the ALTER TABLE ADD FOREIGN KEY statement.
  For example, ALTER TABLE t2 ADD CONSTRAINT c FOREIGN KEY (b) REFERENCES t1(a) RELY ENABLE NOVALIDATE; would become ALTER TABLE t2 ADD CONSTRAINT c FOREIGN KEY (b) REFERENCES t1(a);
   
• ERH 2070 - Removes the INTERVAL clause for automatic partitioning in a CREATE TABLE statement.
  For example, CREATE TABLE tab (a NUMBER, d DATE) PARTITION BY RANGE (d) INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) will become CREATE TABLE tab (a NUMBER, d DATE) PARTITION BY RANGE (d)
   
• ERH 2071 - Removes the SUBPARTITIONS count clause from a CREATE TABLE statement.
  For example, the DDL CREATE TABLE t(a NUMBER, b VARCHAR2(4)) PARTITION BY LIST(b) SUBPARTITION BY HASH(a) SUBPARTITIONS 64 (PARTITION PART_AA ... would become CREATE TABLE t(a NUMBER, b VARCHAR2(4)) PARTITION BY LIST(b) SUBPARTITION BY HASH(a) (PARTITION PART_AA ...
   
• ERH 2072 - Removes the DEFAULT COLLATION clause from the source DDL for tables and views.
  For example, CREATE TABLE A(B VARCHAR2(40) COLLATE USING_NLS_COMP) DEFAULT COLLATION USING_NLS_COMP; changes to CREATE TABLE A(B VARCHAR2(40) COLLATE USING_NLS_COMP);

Knowledge Base

Following is the new knowledge base entry added:

• Collation for table columns
  If the .sql script extracted from Oracle contains a COLLATE clause in columns and the specified collation is not available in Advanced Server, then you must create the required collation.

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