cancel
Showing results for 
Search instead for 
Did you mean: 

EDB Migration PortalⓇ 2.0.0

Technical Alert/Update Information

Technical Alert Name
EDB Technical Update for Migration PortalⓇ 2.0.0
Product Type
EDB Postgres Migration Portal
Release Date
5/21/2019
Technical Alert Details
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
Version history
Revision #:
1 of 1
Last update:
a month ago
Updated by:
 
Labels (2)
Contributors