# darold/ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

Repository: https://github.com/darold/ora2pg
Canonical: https://ross.abutalabs.com/products/ora2pg
Homepage: http://www.ora2pg.com/
Language: Perl
License: GPL-3.0
License Family: copyleft
Last push: 2026-08-06T20:27:37+00:00

## Health v2 (maintenance only)
Score: 66/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 96, release rhythm 8, longevity 100
- inputs: {"age_days": 5287, "days_push": 27, "days_rel": 500, "gap_med": null, "n_releases_24m": 1}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1231, forks 380 (observed 2026-08-28T04:04:04.274257+00:00)

## What it is
Ora2Pg is a free Perl-based tool that migrates an Oracle database to PostgreSQL by scanning the source database and generating SQL scripts for schema and data. It supports exporting tables, views, sequences, indexes, triggers, procedures, packages, partitions, grants, and data, plus migration cost assessment.

## Use cases
- migrate an Oracle database to PostgreSQL
- convert Oracle schema to PostgreSQL compatible SQL
- assess migration cost and difficulty of an Oracle database
- export Oracle data as INSERT or COPY statements
- reverse engineer an Oracle database structure
- convert PL/SQL code to PL/pgSQL
- replicate some Oracle tables into PostgreSQL

## When to choose
- you need to move an Oracle database or schema to PostgreSQL
- you want a scriptable, configurable migration tool with fine-grained export control
- you need a migration cost/difficulty assessment before planning a move
- you want to export Oracle tables as foreign data wrapper tables

## When to avoid
- you need zero-downtime online migration with CDC and rollback (consider commercial tooling)
- your source database is not Oracle or MySQL
- you need fully automatic PL/SQL conversion without manual fixes

## Facets
- artifact type: cli-tool
- maturity: active
- function: database, etl, developer-tools
- domain: databases, developer-tools
- platform: cli, cross-platform, windows
- tags: oracle, postgresql, database-migration, schema-conversion, plsql, sql-generation, perl, automation, linux, macos

## Member repositories
- darold/ora2pg (main) score 66

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:04.274257+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T08:22:29.565632+00:00, confidence not recorded.
  - readme: https://github.com/darold/ora2pg (fetched 2026-08-28T04:04:04.274257+00:00, sha 8cbe95d5b58f)
  - homepage: http://www.ora2pg.com/ (fetched 2026-08-29T12:22:09.403147+00:00, sha 8c52dc61c781)
  - site_page: https://www.ora2pg.com/docs (fetched 2026-08-29T12:22:09.412378+00:00, sha 3c44fee21499)
- Data as of 2026-08-30T08:39:29.467469+00:00.