What’s New

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

  • COMMENTS on Columns, Tables, and Materialized Views are supported.

  • All user schemas can be extracted from the current database.

  • Project compatibility percentage and the total number of schemas for a project can be viewed with the project name. In addition, other UI changes are made to improve user experience.

New Repair Handlers

The following repair handlers are added to improve the Advance 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

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

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