cancel
Showing results for 
Search instead for 
Did you mean: 

EDB Postgres Migration Portal 1.1.0

EDB Postgres Migration Portal 1.1.0

Technical Alert Name
EDB Postgres Migration Portal 1.1.0
Product Type
EDB Postgres Migration Portal
Release Date
3/29/2019
Technical Alert Details
Technical Update
EDB Postgres Migration Portal 1.1.0
 

 
WHAT’S NEW
 
EDB Postgres™ Migration Portal (Migration Portal) is a web-based 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:
 
  • Case sensitivity
  • Starting this release, the Migration Portal and EDB DDL Extractor tool will preserve the case of mixed case identifiers. If an identifier is all uppercase (the Oracle default) it will be converted to all lowercase (the Postgres default). 
Note: You must use the latest EDB DDL Extractor tool to preserve case sensitivity for the extracted ddl files.
  • Reserved keyword support
  • EDB reserved words as object name or variable name is supported.
  • Auto assessment of dependent objects
  • Migration Portal will automatically assess all the dependent objects while reassessing any object. This feature saves efforts of manual reassessment of dependent objects.
  • New Repair Handlers
  • Following is the new repair handler added to improve the Advanced Server compatibility ratio:
  • ERH‌-2061 : In Advanced Server for all the PL/SQL objects, if the END Label is a reserved word, the END Label is enclosed with double quotes.

 
TELL ME MORE
 
For more details, please review the EDB Postgres Migration Portal documentation:
https://www.enterprisedb.com/docs/en/1.1.0/EDB_Migration_Portal_v1.1.0/toc.html

 
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 #:
2 of 2
Last update:
‎04-01-2019 06:55 AM
Updated by:
 
Labels (2)
Contributors