EDB Technical Update for Migration PortalⓇ 2.0.0

This article was originally published on May 21, 2019

TECHNICAL UPDATE
EDB Migration Portal^Ⓡ2.0.0

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.

User-added image

Figure1.2: Migration Portal new look

Reports:

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.

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

Search

Was this article helpful?