Ora2Pg
ora2pg.darold.net
- Free plan
- Windows
- Linux
- Self-hosted
What Ora2Pg is
Ora2Pg scans databases and generates SQL for moving their structure or data to PostgreSQL. It lists Oracle and MySQL as sources, with MariaDB and Microsoft SQL Server migration also mentioned. For Oracle projects, it can produce database content reports and assess migration cost and difficulty. Exports can include tables, views, indexes, constraints, functions, triggers, procedures and packages, with basic automatic conversion from PL/SQL to PL/pgSQL. You can export all data or select rows with a WHERE clause; Oracle BLOBs can be represented as PostgreSQL BYTEA. Other outputs include spatial geometries for PostGIS, DBLINK as Oracle FDW, and Pentaho Data Integrator XML files. By default, it creates files for loading with psql, though direct PostgreSQL import is available after configuring a database connection. Ora2Pg is self-hosted software for Linux and Windows, and the project says it works on any platform. It is free under GPL version 3 or later. Oracle migration requires Perl 5.10 or later, DBI and Oracle client libraries. Generated Oracle-specific code may need manual review and changes.
Who it suits
Ora2Pg suits teams moving Oracle or other listed database content into PostgreSQL, especially those that want assessment reports and export control. Users should be prepared to install the required dependencies and review converted Oracle-specific code.
Good to know, and what to watch
- Assesses Oracle migration cost and difficulty.
- Exports schema objects and selected data.
- Supports PostGIS, Oracle FDW and Pentaho XML.
- Free software under GPL version 3 or later.
- Oracle migration requires Perl, DBI and client libraries.
- Generated Oracle-specific code may need manual changes.
- No free trial is listed.
Plans
Every plan and priceOra2Pg
Free plan
The verdict
Ora2Pg provides a broad set of database export and migration functions, including assessment and several specialized outputs. Its automatic code conversion is basic, so plan for review and possible manual edits.
What the maker publishes
- Assessment
- It can generate database content reports and assess Oracle database and code migration cost and difficulty. source
- Data export
- It can export full data or data selected with a WHERE clause, and supports Oracle BLOB objects as PostgreSQL BYTEA. source
- License
- Ora2Pg is free software distributed under GNU GPL version 3 or any later version, without warranty. source
- Maintainer and history
- The site identifies Gilles Darold as creator and maintainer and says the project has over 25 years of development. source
- Manual work
- The site says generated Oracle-specific PL/SQL code must be reviewed and may need manual changes to match PostgreSQL syntax. source
- Operating systems
- The features page says Ora2Pg works on any platform; the installation guide describes Windows setup and Linux package building. source
- Other integrations
- It can generate Pentaho Data Integrator (Kettle) XML files, export spatial geometries into PostGIS, and export DBLINK as Oracle FDW. source
- Output and loading
- By default, Ora2Pg exports to files loadable with psql; direct import into PostgreSQL is also available by configuring its database connection. source
- Purpose
- Ora2Pg scans Oracle databases, extracts their structure or data, and generates SQL for PostgreSQL. source
- 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. source
- 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. source
- 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. source
- Support
- Commercial migration planning, execution, and support are available through HexaCluster; users can report issues and contribute through the project repository or email. source
Checked against the maker's pages on 3 Oct 2026.