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. observed · 2026-08-28
Health v2 · maintenance only
66/100
- Activity 96
- Release rhythm 8
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 5287
- days_rel: 500
- days_push: 27
- n_releases_24m: 1
Adoption not part of the score
1231 stars · 380 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
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
cli-tool · maturity active
database etl developer-tools databases developer-tools cli cross-platform windows oracle postgresql database-migration schema-conversion plsql sql-generation perl automation linux macos
3 sources
- readme: https://github.com/darold/ora2pg · fetched 2026-08-28 · 8cbe95d5b58f
- homepage: http://www.ora2pg.com/ · fetched 2026-08-29 · 8c52dc61c781
- site_page: https://www.ora2pg.com/docs · fetched 2026-08-29 · 3c44fee21499
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| darold/ora2pg | main | 66 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem