Skip to content
SPECIFICTION
Get listed

Ora2Pg

ora2pg.darold.net

Free plan WindowsLinuxSelf-hosted
Visit ora2pg.darold.net
Spec score 7.4 #10 of 25 in Data Migration Tools

What it is

Ora2Pg is free, self-hosted software for assessing and migrating databases to PostgreSQL. It scans Oracle databases, extracts structures or data, and generates SQL; the site also lists MySQL as a source and mentions MariaDB and Microsoft SQL Server migration. Reports can estimate migration difficulty and cost. Exports include tables, views, indexes, constraints, functions, triggers, procedures, and packages, with basic automatic PL/SQL-to-PL/pgSQL conversion. Data can be exported completely or selected with a WHERE clause, including Oracle BLOBs as PostgreSQL BYTEA. Ora2Pg can generate Pentaho Data Integrator XML, send spatial geometries to PostGIS, and export DBLINK as Oracle FDW. By default it writes files for psql loading, while direct PostgreSQL import is available after configuring a connection. Oracle migrations require Perl 5.10 or later, DBI, and Oracle client libraries; other sources need their drivers and client dependencies. Generated Oracle-specific PL/SQL may require manual review and changes. The software is distributed under GPL version 3 or later.

Spec sheet

Purpose
Ora2Pg scans Oracle databases, extracts their structure or data, and generates SQL for PostgreSQL.Read 3 Oct 2026 · ora2pg.darold.net
Support
Commercial migration planning, execution, and support are available through HexaCluster; users can report issues and contribute through the project repository or email.Read 3 Oct 2026 · ora2pg.darold.net
License
Ora2Pg is free software distributed under GNU GPL version 3 or any later version, without warranty.Read 3 Oct 2026 · ora2pg.darold.net
Assessment
It can generate database content reports and assess Oracle database and code migration cost and difficulty.Read 3 Oct 2026 · ora2pg.darold.net
Data export
It can export full data or data selected with a WHERE clause, and supports Oracle BLOB objects as PostgreSQL BYTEA.Read 3 Oct 2026 · ora2pg.darold.net
Maintainer and history
The site identifies Gilles Darold as creator and maintainer and says the project has over 25 years of development.Read 3 Oct 2026 · ora2pg.darold.net
Manual work
The site says generated Oracle-specific PL/SQL code must be reviewed and may need manual changes to match PostgreSQL syntax.Read 3 Oct 2026 · ora2pg.darold.net
Operating systems
The features page says Ora2Pg works on any platform; the installation guide describes Windows setup and Linux package building.Read 3 Oct 2026 · ora2pg.darold.net
Other integrations
It can generate Pentaho Data Integrator (Kettle) XML files, export spatial geometries into PostGIS, and export DBLINK as Oracle FDW.Read 3 Oct 2026 · ora2pg.darold.net
Output and loading
By default, Ora2Pg exports to files loadable with psql; direct import into PostgreSQL is also available by configuring its database connection.Read 3 Oct 2026 · ora2pg.darold.net
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.Read 3 Oct 2026 · ora2pg.darold.net
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.Read 3 Oct 2026 · ora2pg.darold.net
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.Read 3 Oct 2026 · ora2pg.darold.net

Plans and prices

Ora2Pg Free Free software · use without charge · GPL v3 Read 3 Oct 2026 · ora2pg.darold.net

Every Ora2Pg plan and price →

Strong points and limits

Strong points

  • Free under GPL version 3 or later
  • Migration assessment reports estimate cost and difficulty
  • Exports schemas, code, and selected data
  • Supports PostGIS and Oracle FDW outputs
  • Direct PostgreSQL import is available

Limits

  • Generated PL/SQL may need manual changes
  • Oracle migrations require client libraries
  • Other sources require their database drivers
  • No continuous replication

Who it suits

Ora2Pg suits database teams planning Oracle or other listed-source migrations to PostgreSQL and needing assessment reports, conversion, and export tooling. It is intended for self-hosted environments.

Verdict

Ora2Pg provides broad migration assessment and export functions for PostgreSQL projects, including schema, data, spatial, and integration outputs. Budget time for dependency setup and manual review of Oracle-specific code.

Where Specifiction places it

Alternatives to Ora2PgAll alternatives →