Ora2Pg

Windows · Linux · Self-hosted

Freedom report

Two barsScore 6.4

Free tierA free tier is on its own pricing page
Open codeNo open-source code on record
Runs widely2 of 6 device platforms
DocumentedPlans, terms and facts published

Ora2Pg is ranked #7 of 24 in cloud migration tools on Freedom251. 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

Two bars AWS Transform MGN (formerly AWS Application Migration Service) Free tier No. 1Free6.5 Two bars Google Cloud Migration Center Free tier No. 2Free6.5 Two bars Tencent Cloud Cloud Migration Service Free tier No. 3Free6.5 One bar Amazon Database Migration Service Free tier No. 4Free6.4 One bar AWS Schema Conversion Tool Free tier No. 5Free6.4 One bar Google Migrate to Containers Free tier No. 6Free6.4

The record

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

Where it ranks on Freedom251

Best Cloud Migration Tools in 2026#7 of 24

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