EDB Technical Update for PostgresTM  Migration Portal  2.6.0

TECHNICAL UPDATE
EDB Postgres^TM  Migration Portal  2.6.0

WHAT’S NEW
This is to update you about the release of EDB Postgres^TM Migration Portal 2.6.0, the latest version of the web-based self-service tool for assessing and migrating Oracle database schemas to the EDB Postgres Platform. Users can quickly and conveniently evaluate the feasibility of migrating one or multiple database schemas from Oracle to Postgres, minimizing the time and risk typically involved with database migrations.

Highlights of this release:
 

Feature	Benefit
COMMENTS on Columns, Tables, and Materialized Views are now extracted and assessed on Migration Portal.	Users and administrators save time because important metadata is retained after migration.
Extracting all user schemas: You can now extract all user schemas from the current database. Note: It is recommended to specify the schema names while extracting objects.	No need to manually specify user schemas during migration.
Improved User Experience: You can now view the project compatibility percentage and the total number of schemas for a project with the project name.	Improves efficiency by providing important migration project statistics in a single view. Additional UI changes will help users navigate through the portal more easily.

New Repair Handlers

Following are the new repair handlers added to improve the Advanced Server compatibility ratio:

• ERH 2087 - Removes RESULT_CACHE from the DDL statement.
  
  For example,
  CREATE OR REPLACE FUNCTION get_complete_address RETURN VARCHAR2 RESULT_CACHE
  IS
       person_details VARCHAR2(130);
  BEGIN
       NULL;
  END get_complete_address;
  
  would become;
  CREATE OR REPLACE FUNCTION get_complete_address RETURN VARCHAR2
  IS
       person_details VARCHAR2(130);
  BEGIN
       NULL;
  END get_complete_address;
   
• ERH 2088 - Replaces VIRTUAL keyword with STORED in TABLE definition.
  
  For example,
  CREATE TABLE EMP1 (
  EID number,
  SAL number GENERATED ALWAYS AS (EID*(2+2)) VIRTUAL
  );
  
  would become;
  CREATE TABLE EMP (
  EID number,
  SAL number GENERATED ALWAYS AS (EID*(2+2)) STORED
  );
   
• ERH 2089 - Removes empty spaces from operators i.e. < = , > = , ! = OR < >
  
  For example,
  select 1 from dual where to_date('01/01/2020', 'dd/mm/yyyy') < = sysdate;
  
  would become;
  select 1 from dual where to_date('01/01/2020', 'dd/mm/yyyy') <= sysdate;
   

Knowledge Base

Following are the new knowledge base entries added:

• Foreign Key Constraints on Partitioned Tables
  Oracle supports creating foreign key constraints on the partitioned tables. Advanced Server v11 onwards, creating foreign key constraints on the partitioned tables is supported; however, the earlier versions of Advanced Server do not support this functionality. So, we recommend assessing the schema on the latest Advanced Server version for better assessment results.
   
• SYS_GUID() workaround
  Oracle supports SYS_GUID() function, which generates and returns a globally unique identifier (RAW value). Advanced Server v12 onwards, SYS_GUID() function is supported; however, the earlier versions of Advanced Server do not support SYS_GUID() function. The workaround for the earlier versions is available on the Portal Wiki.
   
• Count(*) with ORDER BY clause
  Oracle supports the ORDER BY clause along with simple count(*) operation on a table. However, Advanced Server does not support the ORDER BY clause along with simple count(*). Advanced Server expects a column that appeared in the ORDER BY clause to be part of the GROUP BY clause as well.
• Indexes on String literal
  Advanced Server does not support index creation on the string literal, however; it allows index creation on columns.

Fixed Customer Defects/Enhancements

• The 'EDB DDL Extractor' of Migration Portal doesn't extract the comments added on columns of a table from Oracle. [NGMTK 1174, Support Ticket 943879]

 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