Posts

Posted on

How to Install ora2pg on Ubuntu and Run a Migration Assessment Report

Ocean Sand, Bahamas

TL;DR: Installing ora2pg on Ubuntu 24.04 requires three components: Oracle Instant Client 19c (for the Oracle connection libraries), the DBD::Oracle Perl module (which links against those libraries), and ora2pg itself (installed from source — it is not on CPAN). Once installed, a single command connects to your Oracle database, scans every object in the schema, and produces an HTML report with a complexity score and an effort estimate in person-days. This post covers the full installation and the report command.

Continue reading “How to Install ora2pg on Ubuntu and Run a Migration Assessment Report”
Posted on

Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples

NASA Space Telescopes See Weather Patterns in Brown Dwarf

TL;DR: The manual work in an Oracle to PostgreSQL migration depends entirely on how the schema was built — not on its size.
This guide maps three common Oracle schema patterns to the specific migration example that covers each one: legacy OLTP, modern OLTP, and data warehouse.
If you are unsure which applies to your database, the diagnostic section below gives you four questions to find out.

Continue reading “Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples”