pgrecon released for Oracle to PostgreSQL migration assessment

Brief written by the FOSSWire AI editor from PostgreSQL How we write

October 22, 2026 1 min read

Key Takeaway

pgrecon is an Apache-2.0 licensed tool that performs offline Oracle schema assessment and conversion to PostgreSQL.

Summary

The pgrecon 0.7.3 release provides an open-source solution for migrating from Oracle to PostgreSQL. The tool operates entirely offline by using a read-only SQL*Plus script to generate a dump, which is then analyzed locally. It assesses data types, PL/SQL constructs, and partitioning, while providing a residue report for elements that cannot be faithfully converted.

Technical capabilities of pgrecon

Offline operation: Uses a reviewable SQL*Plus script to build a local inventory without connecting to databases.
Rule engine: Runs 80 rules covering data types, storage, partitioning, and PL/SQL grammar parsing.
DDL Conversion: Supports tables, constraints, indexes, sequences, views (converting CONNECT BY to WITH RECURSIVE), materialized views, and MERGE statements.
Compatibility: Supports Oracle 9.2 through 23ai and PostgreSQL 16, 17, and 18.
Verification: Uses a schema fuzzer and nightly CI testing against multiple Oracle XE and Free versions.

Why it matters

The tool provides a deterministic way for enterprises to estimate migration effort and automate schema conversion while maintaining data integrity through residue reporting.

Original reference: www.postgresql.org →