Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Ora2Pg

ora2pg.darold.net

  • Free plan
  • Windows
  • Linux
  • Self-hosted
7.2 Club score Visit ora2pg.darold.net

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.

Ora2Pg

Free

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.