cancel
Showing results for 
Search instead for 
Did you mean: 

Technical Update for EDB Migration PortalⓇ 2.4.0

Technical Alert/Update Information

Technical Alert Name
Technical Alert for EDB Migration PortalⓇ 2.4.0
Product Type
EDB Postgres Migration Portal
Release Date
12/12/2019
Technical Alert Details
 
TECHNICAL UPDATE
EDB Migration PortalⓇ  2.4.0

WHAT’S NEW
This update is notifying you of a new software release EDB Migration Portal 2.4.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:
  • Advanced Server version 12 support
Starting this release, Migration Portal supports Advanced Server 12 as a target database. So now you can assess or reassess your Oracle schema against Advanced Server version 12. For more information, see the Advanced Server Guide.
  • Minor UI changes
Few minor changes are made in the new UI for better user experience.

New Repair Handlers

Following are the new repair handlers added to improve the Advanced Server compatibility ratio:
  • ERH 2080 - Converts SIMPLE_INTEGER data type to INTEGER type.
    For example, CREATE OR REPLACE PROCEDURE hr.mproc IS
    v_col1 SIMPLE_INTEGER := 1;
    BEGIN
    DBMS_OUTPUT.PUT_LINE('Simple Integer is' || v_col1);
    END;
would become CREATE OR REPLACE PROCEDURE hr.mproc IS
v_col1 INTEGER := 1;
BEGIN    
DBMS_OUTPUT.PUT_LINE('Simple Integer is' || v_col1);
END;
  • ERH 2081 - Converts NATURAL data type to INTEGER type.
    For example, CREATE OR REPLACE PROCEDURE hr.mproc IS
    v_col1 NATURAL := 1;
    BEGIN
    DBMS_OUTPUT.PUT_LINE('Natural Integer is' || v_col1);
    END;
    would become CREATE OR REPLACE PROCEDURE hr.mproc IS
    v_col1 INTEGER := 1;
    BEGIN
    DBMS_OUTPUT.PUT_LINE('Natural Integer is' || v_col1);
    END;
     
  • ERH 2082 - Removes NOT NULL clause from VARRAY collection type declaration within PL/SQL object.
    For example, TYPE t1 IS VARRAY(10) OF INTEGER NOT NULL;
    would become TYPE t1 IS VARRAY(10) OF INTEGER;
     
  • ERH 2083 - Removes NOT NULL clause from nested table type declaration within PL/SQL object. 
    For example, TYPE nt IS TABLE OF NUMBER NOT NULL;
    would become TYPE nt IS TABLE OF NUMBER;
     
  • ERH 2084 - Removes NOT NULL clause from index-by table type declaration within PL/SQL object.
    For example, TYPE ft IS TABLE OF VARCHAR2(10) NOT NULL INDEX BY BINARY_INTEGER;
    would become TYPE ft IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
     
  • ERH 2085 - Converts ARRAY to VARRAY collection type declaration within PL/SQL object.
    For example, TYPE t1 IS ARRAY(10) OF INTEGER; would become TYPE t1 IS VARRAY(10) OF INTEGER;
     
  • ERH 1010 - Removes the label name from the END clause in SPL object if the label name used in the start of the clause is different. For example
    For example, CREATE OR REPLACE FUNCTION hr.emp_comp (n INTEGER) RETURN NUMBER IS
    DECLARE
    counter INTEGER;
    BEGIN
    LOOP EXIT WHEN counter = n;
    counter := counter + 1;
    END LOOP;
    RETURN 100;
    END emp_comp_123;
    would become CREATE OR REPLACE FUNCTION hr.emp_comp (n INTEGER) RETURN NUMBER IS DECLARE
    counter INTEGER;
    BEGIN
    LOOP EXIT WHEN counter = n;
    counter := counter + 1;
    END LOOP;
    RETURN 100;
    END ;

Knowledge Base

Following are the new knowledge base entries added:
  • Use of EXECUTE IMMEDIATE USING IN/OUT parameter
    Oracle supports use of syntax EXECUTE IMMEDIATE <SQL or SPL Commands> [USING <bind variable list>]. However, Advanced Server does not support IN/OUT parameters in EXECUTE IMMEDIATE USING syntax.
     
  • Operator does not exist: timestamp without timezone and double precision
    Oracle supports addition operation between timestamp without time zone and double precision datatypes in SQL operations or in VIEW/MVIEW creation. However, in Advanced Server double precision datatype needs to type cast to numeric data type while adding it to timestamp without time zone datatype.
     
  • Extract function for XML
    Oracle supports extract() function for both extracting date part as well as for extracting XML data.
     
  • Migrating Database Links
    While migrating the Database links from Oracle to Advanced Server sometimes following errors occur:
    Error
    ORA-12154: TNS: could not resolve the connect identifier specified
    server "db_link_name" does not exist.

Fixed Customer Defects

  • Issue with procedure compatibility fails for GREATEST function with error message as “Incompatible function/package found: GREATEST”. [NGMTK 1154, Support Ticket 934088]
  • EDB migration portal doesn't work for a view already extracted [NGMTK 1109, Support Ticket 922742]
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:
‎12-13-2019 08:25 AM
Updated by:
 
Labels (1)
Contributors