Ora2Pg
Ora2Pg is self-hosted software for moving database structures and data to PostgreSQL.
What Ora2Pg is
Ora2Pg is self-hosted software for moving database structures and data to PostgreSQL. It scans Oracle databases and generates SQL, and the site also lists MySQL as a source, with MariaDB and Microsoft SQL Server migration mentioned among its features. It can assess Oracle migration cost and difficulty and create database content reports. Exports cover objects such as tables, views, indexes, functions, triggers, procedures, and packages; basic automatic conversion translates PL/SQL toward PL/pgSQL. You can export all data or select rows with a WHERE clause, including Oracle BLOBs as PostgreSQL BYTEA. It can also produce Pentaho Data Integrator XML, send spatial geometries to PostGIS, and export DBLINK as Oracle FDW. By default, it writes files for loading with psql, though direct PostgreSQL import is available after configuring a connection. Ora2Pg is free under GPL version 3 or later. Oracle migrations require Perl 5.10 or later, DBI, and Oracle client libraries. Generated Oracle-specific PL/SQL may need manual review and changes for PostgreSQL.
Good
- Free software under GPL version 3 or later.
- Assesses Oracle migration cost and difficulty.
- Exports database objects and selected data.
- Supports spatial export to PostGIS.
Watch out
- Oracle migrations require Perl, DBI, and client libraries.
- Generated Oracle-specific code may need manual changes.
Who it suits
It suits teams planning Oracle database migration to PostgreSQL, including those that want to assess migration effort or export selected data. It is a fit for users able to manage a self-hosted tool and its migration dependencies.
Verdict
Ora2Pg offers a broad set of database export and assessment functions without a software charge. Plan for its dependencies and review generated Oracle-specific code before using it with PostgreSQL.
Plans and prices
From Ora2Pg's own pricing page, checked 3 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Ora2Pg | Free | Free software · use without charge · GPL v3 |
The facts
Each one read from Ora2Pg's own pages, with the date it was checked.
What it does
- Assessment
- It can generate database content reports and assess Oracle database and code migration cost and difficulty.checked 3 Oct 2026
- Data export
- It can export full data or data selected with a WHERE clause, and supports Oracle BLOB objects as PostgreSQL BYTEA.checked 3 Oct 2026
- License
- Ora2Pg is free software distributed under GNU GPL version 3 or any later version, without warranty.checked 3 Oct 2026
- Maintainer and history
- The site identifies Gilles Darold as creator and maintainer and says the project has over 25 years of development.checked 3 Oct 2026
- Manual work
- The site says generated Oracle-specific PL/SQL code must be reviewed and may need manual changes to match PostgreSQL syntax.checked 3 Oct 2026
- Operating systems
- The features page says Ora2Pg works on any platform; the installation guide describes Windows setup and Linux package building.checked 3 Oct 2026
- Other integrations
- It can generate Pentaho Data Integrator (Kettle) XML files, export spatial geometries into PostGIS, and export DBLINK as Oracle FDW.checked 3 Oct 2026
- Output and loading
- By default, Ora2Pg exports to files loadable with psql; direct import into PostgreSQL is also available by configuring its database connection.checked 3 Oct 2026
- Purpose
- Ora2Pg scans Oracle databases, extracts their structure or data, and generates SQL for PostgreSQL.checked 3 Oct 2026
- Requirements
- The guide requires Perl 5.10 or later, DBI, and Oracle client libraries for Oracle migrations; MySQL and SQL Server exports require their corresponding Perl database drivers and client dependencies.checked 3 Oct 2026
- Schema and code conversion
- It exports database objects including tables, views, indexes, constraints, functions, triggers, procedures, and packages, and provides basic automatic PL/SQL-to-PL/pgSQL conversion.checked 3 Oct 2026
- Sources and target
- The site lists Oracle and MySQL as sources and PostgreSQL as the target; its features page also mentions MariaDB and Microsoft SQL Server migration.checked 3 Oct 2026
- Support
- Commercial migration planning, execution, and support are available through HexaCluster; users can report issues and contribute through the project repository or email.checked 3 Oct 2026
Alternatives to Ora2Pg
- 1
MySQL
Free planAPILinuxmacOSSelf-hosted7.9Free plan - 2
DBConvert Streams
Free planWebAPIExtensionLinux7.2From $9 a month - 3
Amazon Database Migration Service
Free planWebAPI7.0Free plan - 4
pgloader
Free planLinuxSelf-hosted6.6From €800 a month - 5
Striim
Free planWebAPISelf-hosted6.4Free plan - 6
Fivetran HVR
WebAPILinuxSelf-hosted6.3