Ora2Pg

Free plan LinuxSelf-hostedWindows

What Ora2Pg is

Ora2Pg is free, self-hosted software that scans databases and generates SQL for PostgreSQL. It lists Oracle and MySQL as sources, and also mentions MariaDB and Microsoft SQL Server migration. For Oracle databases, it can assess migration cost and difficulty and generate content reports. It exports objects such as tables, views, indexes, constraints, functions, triggers, procedures, and packages, with basic automatic conversion from PL/SQL toward PL/pgSQL. Data export can cover everything or rows selected with a WHERE clause; Oracle BLOBs can be exported as PostgreSQL BYTEA. Other outputs include Pentaho Data Integrator XML, spatial geometries for PostGIS, and DBLINK as Oracle FDW. By default, it creates files loadable with psql, though direct PostgreSQL import is possible after configuring a connection. Oracle migration requires Perl 5.10 or later, DBI, and Oracle client libraries; other sources have their own driver and client dependencies. Generated Oracle-specific PL/SQL may need review and manual changes for PostgreSQL syntax. Ora2Pg is distributed under GPL version 3 or later without warranty.

Who it suits

Ora2Pg suits users planning a self-hosted migration to PostgreSQL, particularly those assessing or exporting Oracle databases. Users should be prepared to meet source-specific dependencies and review generated Oracle-specific code.

What it does well

Free software under GPL version 3 or later.
Assesses Oracle migration cost and difficulty.
Exports selected rows using a WHERE clause.
Can generate PostgreSQL-loadable files or import directly.
Supports spatial geometry export to PostGIS.

What to know first

Oracle migration requires Perl, DBI, and Oracle client libraries.
Generated Oracle-specific code may need manual review.
Other sources require their own drivers and client dependencies.

Plans

Plan	Billed and limits	Price
Ora2Pg	Free software · use without charge · GPL v3	Free

As ora2pg.darold.net lists them, read 3 Oct 2026. The maker's own page has the final word.

Getting started

Visit https://ora2pg.darold.net/
Prepare a Linux or Windows environment and the dependencies for your source database
For Oracle migrations, install Perl 5.10 or later, DBI, and Oracle client libraries
Configure Ora2Pg to scan and export database structures or data
Load the generated files with psql, or configure a database connection for direct PostgreSQL import

Verdict

Ora2Pg offers broad database export and assessment capabilities for PostgreSQL migrations. Plan for source-specific requirements and manual review of converted Oracle code.

Questions

Does Ora2Pg cost anything?

Ora2Pg is free software, priced at $0, and distributed under GNU GPL version 3 or later.

Which databases can it migrate?

The site lists Oracle and MySQL as sources and PostgreSQL as the target. Its features page also mentions MariaDB and Microsoft SQL Server migration.

What operating systems does Ora2Pg support?

The features page says it works on any platform. The installation guide describes Windows setup and Linux package building.

What does an Oracle migration require?

The guide requires Perl 5.10 or later, DBI, and Oracle client libraries. MySQL and SQL Server exports need their corresponding Perl database drivers and client dependencies.

Can Ora2Pg import directly into PostgreSQL?

Yes. By default, it exports files loadable with psql, and direct import is also available after configuring its database connection.

Does Ora2Pg automatically convert Oracle code?

It provides basic automatic PL/SQL-to-PL/pgSQL conversion. Oracle-specific PL/SQL may need review and manual changes to match PostgreSQL syntax.

Facts from Ora2Pg's own pages

Assessment: It can generate database content reports and assess Oracle database and code migration cost and difficulty. · ora2pg.darold.net, 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. · ora2pg.darold.net, 3 Oct 2026
License: Ora2Pg is free software distributed under GNU GPL version 3 or any later version, without warranty. · ora2pg.darold.net, 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. · ora2pg.darold.net, 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. · ora2pg.darold.net, 3 Oct 2026
Operating systems: The features page says Ora2Pg works on any platform; the installation guide describes Windows setup and Linux package building. · ora2pg.darold.net, 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. · ora2pg.darold.net, 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. · ora2pg.darold.net, 3 Oct 2026
Purpose: Ora2Pg scans Oracle databases, extracts their structure or data, and generates SQL for PostgreSQL. · ora2pg.darold.net, 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. · ora2pg.darold.net, 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. · ora2pg.darold.net, 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. · ora2pg.darold.net, 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. · ora2pg.darold.net, 3 Oct 2026

Where Ora2Pg stands on Freedom251

Data Migration Tools#6 of 25
Cloud Migration Tools#8 of 32