What’s New

The following features are added to the EDB Postgres Migration Portal for this release:

  • Minor changes are made in the new user interface for a better user experience.
  • Effective this release, the old user interface 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 2068: Replaces MODIFY keyword with ALTER keyword and inserts the word TYPE between attribute name and its intended new data type.

    For example, ALTER TYPE t MODIFY ATTRIBUTE p VARCHAR2(4) CASCADE would become ALTER TYPE t ALTER ATTRIBUTE p TYPE VARCHAR2(4)CASCADE

  • 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

The following new knowledge base entry is added; refer to the Knowledge Base section on the Migration Portal for workaround details.

  • 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.