HexaRocket Release Announcement to support Oracle to PostgreSQL Migration (Initial Launch April 2025)

Introduction

We are excited to announce the very first release of HexaRocket, delivering full end-to-end support for Oracle to PostgreSQL migrations. As the original authors of Ora2Pg, we understood early on that enterprises need more than standalone tools. Enterprises need a unified, reliable, and easy-to-use platform that handles Schema Migration, Data Migration, and CDC-based Online Replication in one place.

This release marks a major milestone combining automation, performance, real-time change capture, and an intuitive UI to simplify even the largest and most complex Oracle workloads.

Why We Built HexaRocket

Users migrating from Oracle have consistently asked for -

• A click-based migration workflow instead of multiple command-line tools
• Users need to use more than one tool to perform Schema Migration, Data Migration and CDC for continuous replication of changes for Online migrations.
• A single UI to plan, run, monitor, pause, resume, and restart migrations
• The ability to restart a single table without re-running the entire project
• Parallel workers for faster Data Migration
• A simple, unified experience that removes guesswork and friction

HexaRocket was built to solve these exact challenges, combining our deep migration experience with enterprise-grade automation.

Overview

HexaRocket now provides complete support for migrating Oracle databases to PostgreSQL, including:

1. Schema Migration (Comprehensive Object Coverage)

Automatically extracts, converts, and deploys all major Oracle object types to PostgreSQL, including

• Tables
• Partitioned Tables
• Indexes & Constraints
• Custom Types (UDTs)
• Functions & Stored Procedures
• Packages & Package Bodies
• Views & Materialized Views
• Triggers

HexaRocket ensures accurate translation of Oracle semantics to PostgreSQL standards, reducing manual rewrites and validation effort.

2. High-Performance Data Migration

• Automatic mapping of data types between Oracle and PostgreSQL based on the source and the target schema
• Supports every possible data type for data migration
• Parallel table-level workers for faster data migration
• Transparent retry and restart capabilities
• Ability to restart a specific table without rerunning the entire job

3. CDC for Online Replication

• Real-time change capture from Oracle
• Powerful parallel workers for extraction behind the scenes
• Applied to PostgreSQL using parallel workers
• Supports pause, resume, and termination directly from the UI

Together, these features enable seamless, large-scale Oracle migrations with dramatically reduced downtime.

Who This Is For

This release is ideal for -

• Organizations modernizing legacy Oracle systems
• Teams looking to reduce Oracle licensing and infrastructure costs
• Companies adopting PostgreSQL for scalability, flexibility, and open-source advantages
• Enterprises requiring online, low-downtime migration paths
• Anyone seeking a guided, visual migration experience rather than scripts and manual processes

Beyond Oracle to PostgreSQL

HexaRocket is built as a universal migration platform, supporting end-to-end Schema Migration, Data Migration, and CDC-based online replication across Oracle, SQL Server, MySQL, MariaDB and PostgreSQL as of Nov, 2025.

Along with the tool license, HexaCluster also offers expert Database Migration Consulting Services for complex Oracle compatibility in PostgreSQL through custom extensions, performance tuning, PostgreSQL design and setup, and deep database optimization.

Our team further provides Application Migration and Modernization Consulting to help organizations seamlessly transition their application stack alongside the database.

For migration discussions, demos, or support, reach us anytime at connect@hexacluster.ai