WHAT’S NEW This update is notifying you of a new software release EDB Migration Portal 2.0.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:
New and enhanced UI:
Starting this release, Migration Portal has a new and improved look, with easy navigation and enhanced summary view.
Figure1.2: Migration Portal new look
You can view and download the detailed report of the assessed schemas for any project. For more information, see section 3.3.
New Repair Handlers The following repair handlers are added to improve the Advance Server compatibility ratio:
ERH 2062: Removes the Supplemental logging clause from the table DDL.
For example, CREATE TABLE test(CODE int PRIMARY KEY, SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS); would become CREATE TABLE test(CODE int PRIMARY KEY);
ERH: 2063: Removes the Supplemental logging group clause from the table DDL.
For example CREATE TABLE test(t_id integer, SUPPLEMENTAL LOG GROUP slgroup (t_id) ALWAYS); would become CREATE TABLE test(t_id integer);
ERH 2064: Removes DEFERRABLE clause from CHECK and NOT NULL constraints in table DDL.
Knowledge Base The following new knowledge base entry is added, refer to the Knowledge Base section on the Migration Portal for workaround details.
Syntax error for declaring types as NULL
While declaring package types, Oracle allows NULL for a certain type member. However, Advanced Server does not support this syntax.
Selecting ROWID from table
By default, Oracle tables are created with associated ROWID for each row. However, in Advanced Server you must enable default_with_rowids and default_with_oids parameters to use Oracle’s ROWID.
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