Ora2Pg
Ora2Pg Logo
The open-source Oracle to PostgreSQL migration toolkit.

A free tool to migrate Oracle (and MySQL) databases to PostgreSQL. It connects to your Oracle database, scans it automatically, extracts its structure or data, and generates SQL scripts you can load directly into PostgreSQL. 25+ years of development. Thousands of successful migrations. Created by Gilles Darold, CTO of HexaCluster and currently being maintained by Gilles and the Team at HexaCluster.

Version 25.0
GPL v3

HexaRocket

Ora2Pg+ for Enterprises

HexaRocket, built by the creators of Ora2Pg, addresses all the conversion challenges that cannot be handled by Ora2Pg and reduces manual efforts. HexaRocket supports Online database migrations with Rollback capabilities.

  • 100% automatic schema conversion with validation
  • Data Migration with Validation
  • CDC for live replication - Online migration with Rollback
  • Cutover Prechecks and advanced configuration on UI

Supported Databases

OracleSQL ServerMariaDBMySQLSybase ASEDB2
www.hexarocket.com

Expert migration help

Stuck with Ora2Pg?

If your migration still needs manual fixes, deeper validation, or production cutover support, HexaCluster can help you move from generated scripts to a migration plan you can trust.

Talk to migration specialists behind Ora2Pg.

Migration Capabilities

Choose the engine that fits the migration.

Start with Ora2Pg's proven open-source workflow, or switch to HexaRocket when the project needs enterprise-grade validation, replication, and operational control.

Open source toolkit

Everything needed for Oracle to PostgreSQL migration.

Ora2Pg focuses on assessment, schema extraction, data export, and SQL conversion for teams that want a powerful, scriptable migration engine.

Sources
OracleMySQL
Targets
PostgreSQL
  • Migration Assessment reports
  • Schema Conversion
  • Oracle PL/SQL to PostgreSQL PL/pgSQL
  • Data Migration (Offline, requires downtime)
  • Data Validation

Ecosystem

Better together.

The world's leading open-source Oracle to Postgres migration engine, seamlessly integrated with HexaRocket's enterprise platform.

Ora2Pg Logo

Ora2Pg

Open Source Engine

HexaRocket Logo

HexaRocket

Enterprise Platform