A new open-source tool, pgrecon, aims to make Oracle-to-PostgreSQL migrations more assessable and repeatable. Released under the Apache-2.0 license, the current version is 0.7.3. pgrecon operates entirely offline: a reviewable, read-only SQL*Plus script produces a dump, and the tool builds a local inventory from it without ever connecting to either database.
A deterministic rule engine runs 80 rules over the inventory, covering data types and length semantics, storage and partitioning, PL/SQL constructs, supplied-package usage, schema objects, and performance posture. Each rule finding includes line-level evidence and remedy guidance. An effort estimator produces person-day ranges from named components with stated assumptions. The converter emits plain PostgreSQL DDL for what it can prove, and everything it cannot carry faithfully is listed as a named line in a residue report, never emitted as DDL.
- Offline-only workflow: read-only SQL*Plus dump, local inventory, no database connections.
- 80-rule deterministic engine covering data types, partitioning, PL/SQL (parsed with a full grammar), supplied packages, schema objects, and performance.
- Effort estimator generates person-day ranges with named components and assumptions.
- Schema conversion emits plain PostgreSQL DDL for tables with native partition children, constraints, indexes, sequences, views, materialized views, comments, grants, simple DML triggers, and standalone routines.
- ROWNUM top-N bounds now become
LIMIT, and MERGE statements are converted. - Residue report captures every object that cannot be faithfully converted.
- Full extraction verification is included (details truncated in source).
For developers planning or executing Oracle-to-PostgreSQL migrations, pgrecon provides a transparent, auditable assessment without requiring direct database access. The rule-based approach and residue report help teams scope effort and identify blockers early, while the converter automates straightforward schema objects. By keeping everything offline and reviewable, pgrecon reduces risk and improves compliance in sensitive environments. The tool is available now, and its open-source nature invites community contributions to expand rule coverage and conversion capabilities.