This article was originally published on August 20, 2020
WHAT’S NEW
This is to update you about the release of Migration Portal 2.9.0, the latest version of the web-based self-service tool for assessing and migrating Oracle database schemas to the EDB Suite. You 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:
* Schema Migration to EDB Postgres Advanced Server:
We’ve given you an easier path to install EDB Postgres Advanced Server from the migration portal so that you don’t have to research how to install it and migrate your schema.
You can migrate your schema using the following options:
- Existing on-premise EDB Postgres Advanced Server
- New on-premise EDB Postgres Advanced Server
- EDB Postgres Advanced Server on the IBM Cloud
For more information, see the Schema Migration topic in the Migration Portal guide.
* Contact Us form: You can now use a Contact Us form directly in the portal to get help migrating, installing, or performing other migration-related tasks.
* Enhanced User Experience: Many changes have been made to the UI to help you navigate the portal more easily.
* Faster Report Generation For Large Projects:
Report generation duration for larger projects has been optimized dramatically, so you don’t need to wait as long to see your migration reports. In our testing, a report that used to take 5-7 minutes to create now takes less than 5 seconds!
Repair Handlers
* New Repair Handler
New repair handlers mean that you don’t have to make as many manual changes to migrate your schema from Oracle to Postgres. Below is a new repair handler we’ve added.
ERH 2090 - Convert Function
Replaces Oracle's CONVERT function with EDB Postgres Advanced Server Compatible convert or convert_to function inside any PL/SQL block.
For example,
CREATE VIEW MY_VIEW1 AS SELECT CONVERT('Ä Ê Í Õ Ø A B C D E','AL32UTF8','WE8ISO8859P1') as CONVERT_TEST FROM dual;
CREATE VIEW MY_VIEW2 AS SELECT CONVERT('Ä Ê Í Õ Ø A B C D E','AL32UTF8') as CONVERT_TEST FROM dual;
would become:
CREATE VIEW MY_VIEW1 AS SELECT convert('Ä Ê Í Õ Ø A B C D E','LATIN1','UTF8') as CONVERT_TEST FROM dual;
CREATE VIEW MY_VIEW2 AS SELECT convert_to('Ä Ê Í Õ Ø A B C D E','UTF8') as CONVERT_TEST FROM dual;
TELL ME MORE
For more details, please review the Migration Portal documentation:
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