Ora2Pg

Ora2Pg is ranked #8 of 23 in cloud migration tools on The Geeks Club. It runs on Linux, Self-hosted, Windows. There is a free plan.

Ora2Pg plans and pricing

All plans

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

Compared on cloud migration tools

Free plan: Yes
Discovery & assessment: Yes
Continuous replication: No
Database migration: Yes
Deployment model: self-hosted

Best Ora2Pg alternatives

See all 12

7.7 Striim Free plan

7.2 Google Cloud Migration Center Free plan

7.1 pgloader Free plan

7.0 Amazon Database Migration Service Free plan

6.9 AWS Transform MGN (formerly AWS Application Migration Service) Free plan

6.8 AWS Schema Conversion Tool Free plan

Ora2Pg

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

Visit site Alternatives

Where it ranks on The Geeks Club

Best Cloud Migration Tools in 2026#8 of 23

Is Ora2Pg yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Claim it free Promote Ora2Pg

Sources

ora2pg.darold.net/docs· checked 3 Oct 2026
ora2pg.darold.net/docs/features· checked 3 Oct 2026
ora2pg.darold.net/docs/installation· checked 3 Oct 2026
ora2pg.darold.net/docs/license· checked 3 Oct 2026
ora2pg.darold.net/support· checked 3 Oct 2026
ora2pg.darold.net· checked 3 Oct 2026
ora2pg.darold.net/license· checked 3 Oct 2026