Ora2Pg

Input—per 1M tokens

Output—per 1M tokens

Context—tokens

WeightsClosed

About

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

Compared on cloud migration tools

Free plan: Yesora2pg.darold.net
Discovery & assessment: Yesora2pg.darold.net
Continuous replication: Noora2pg.darold.net
Database migration: Yesora2pg.darold.net
Deployment model: self-hostedora2pg.darold.net

Facts

Purpose: Ora2Pg scans Oracle databases, extracts their structure or data, and generates SQL for PostgreSQL.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
Assessment: It can generate database content reports and assess Oracle database and code migration cost and difficulty.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
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
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
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
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
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
License: Ora2Pg is free software distributed under GNU GPL version 3 or any later version, without warranty.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
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