# pgrecon released for Oracle to PostgreSQL migration assessment

> **Key takeaway:** pgrecon is an Apache-2.0 licensed tool that performs offline Oracle schema assessment and conversion to PostgreSQL.

**Published:** 2026-10-22T00:00:00+00:00 
**Source:** PostgreSQL Official News 
**Category:** databases-storage 
**Canonical URL:** https://fosswire.org/news/pgrecon-released-for-oracle-to-postgresql-migration-assessme.html 

## 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.