We are pleased to announce the general availability of EDB Migration Portal 4.1. EDB Migration Portal is the free, web-based tool that accelerates your Oracle migration to EDB Postgres Advanced Server (EPAS) by helping you assess the migration effort and automate schema translation and deployment. This release includes enhanced reporting, security improvements, fixes and several other features and updates. We encourage you to read all about this new release here and then to try it for yourself. It’s absolutely free and easy to get started.
Enhanced Migration Portal Assessment Reports
The new schema assessment reports include an analysis of the overall schema migration complexity and rates it on a scale of 1 “Easy” to 5 “Difficult.” The complexity score factors account package sub-functions and other functions that have not yet been implemented as part of EPAS compatibility with Oracle features.
The assessment report is now divided into two sections. The first contains object compatibility percentages as in previous releases and the second section contains the feature analysis and overall complexity-level score. This new section, as seen in the screenshot above, details compatibility of features from Oracle to EPAS.
This enhanced assessment report gives users a better understanding of the overall complexity of the schema migration beyond simple raw object compatibility percentages. It also provides more information about the root cause of incompatibility issues.
Generate Multiple DDL Files
Migration Portal users can now choose to split the DDL that is generated for loading into the target database into multiple files. This allows the deferral of loading object types like indexes and constraints to better support the migration of data. Users may choose to defer loading object types that have not been fully converted from Oracle to EPAS to make migrating data run more smoothly.
The ability to choose a subset of schemas to migrate, as shown in the screenshot above, gives the user greater flexibility in migrating some schema object types earlier to allow testing and development. Other object types can be migrated after the user has addressed compatibility issues. These choices make it easier to migrate data later in the overall migration process.
Repair handlers: added a new repair handler, ERH-3005, to transform Q quoted strings to either dollar quoted or E quoted strings. We’ve also enhanced the ERH-2078 repair handler to apply pipelined specific transformations at the package header level and updated the ERH-2034 repair handler so that it removes NULL from the TYPE definition provided inside a PACKAGE.
Security Improvements: upgraded several code libraries used by the Migration Portal to address security issues recently reported against them
- Fixed a corner case that resulted in the skipping of some indexes when processing source Oracle DDL files generated using the Oracle Data Pump utilities.
- Fixed the behavior where only the ENABLE keyword was being removed from the ENABLE NOVALIDATE clause in ALTER TABLE statements so that the complete clause is now removed. Also, updated the relevant repair handlers ERH-2003 and ERH-2005.
- Fixed a synchronization thread issue that was impacting the performance of other assessments running in parallel with a long-running schema assessment.
- Fixed an issue where the DEDUPLICATE LOB clause in CREATE TABLE statements that are generated by the Oracle Data Pump utilities resulted in DDL parsing related errors.
If you experience any problems installing the new software, please contact Technical Support at:
Phone: US: +1-732-331-1320 or 1-800-235-5891