- Home
- Data Migration Tools
- Ora2Pg
Ora2Pg
What it is
Ora2Pg is free, self-hosted software for assessing and moving database content to PostgreSQL. It scans Oracle databases, extracts structure or data, and generates SQL; the site also lists MySQL as a source and mentions MariaDB and Microsoft SQL Server migration. It can create database content reports and estimate the cost and difficulty of an Oracle migration. Exportable objects include tables, views, indexes, constraints, functions, triggers, procedures, and packages. Basic automatic conversion translates PL/SQL toward PL/pgSQL, but Oracle-specific code may need review and manual changes for PostgreSQL syntax. Data exports can cover a full database or rows selected with a WHERE clause, and Oracle BLOBs can be exported as PostgreSQL BYTEA. Other options include spatial geometry export to PostGIS, DBLINK export as Oracle FDW, and Pentaho Data Integrator XML generation. By default, Ora2Pg produces files for loading with psql; direct PostgreSQL import is also possible after configuring a connection. Oracle migrations require Perl 5.10 or later, DBI, and Oracle client libraries. Other sources require their corresponding drivers and client dependencies.
For and against
For
- Assesses Oracle migration cost and difficulty
- Exports schema objects and selected or full data
- Can export Oracle BLOBs as PostgreSQL BYTEA
- Supports PostGIS, Oracle FDW, and Pentaho XML outputs
Against
- Oracle migrations require Perl, DBI, and Oracle client libraries
- Generated Oracle-specific PL/SQL may need manual changes
- Other source databases require corresponding drivers and dependencies
The verdict
Ora2Pg provides several routes for assessing and exporting database structure and data to PostgreSQL. Plan for dependency setup and manual review of Oracle-specific code rather than assuming conversion is complete.
Who it suits
Ora2Pg suits teams planning a database move to PostgreSQL, especially those assessing Oracle migration scope or converting schema and data. It is aimed at users able to install and configure its required libraries and review converted code.
Plans and prices
Ora2Pg
Free software · use without charge · GPL v3
Read 3 Oct 2026 · ora2pg.darold.net
On the record
- Assessment
- It can generate database content reports and assess Oracle database and code migration cost and difficulty.ora2pg.darold.net · read 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 · read 3 Oct 2026
- License
- Ora2Pg is free software distributed under GNU GPL version 3 or any later version, without warranty.ora2pg.darold.net · read 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 · read 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 · read 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 · read 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 · read 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 · read 3 Oct 2026
- Purpose
- Ora2Pg scans Oracle databases, extracts their structure or data, and generates SQL for PostgreSQL.ora2pg.darold.net · read 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 · read 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 · read 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 · read 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 · read 3 Oct 2026
