ora2pg is an open-source tool used to migrate Oracle databases to PostgreSQL. It connects to an Oracle database, extracts schema and data, and generates SQL-compatible output for PostgreSQL. It supports complex migration scenarios, including stored procedures, triggers, data types, and performance optimization, making it ideal for enterprises transitioning away from Oracle systems.

Features

  • Converts Oracle schema, data, and PL/SQL to PostgreSQL
  • Supports large-scale and complex database migrations
  • Parallel export for improved performance
  • Customizable mapping of Oracle data types to PostgreSQL
  • Provides migration reports and performance tuning tips
  • Command-line interface with extensive configuration options

Project Samples

Project Activity

See All Activity >

Categories

Database

License

GNU General Public License version 3.0 (GPLv3)

Follow Ora2Pg

Ora2Pg Web Site

Other Useful Business Software
Gen AI apps are built with MongoDB Atlas Icon
Gen AI apps are built with MongoDB Atlas

The database for AI-powered applications.

MongoDB Atlas is the developer-friendly database used to build, scale, and run gen AI and LLM-powered apps—without needing a separate vector database. Atlas offers built-in vector search, global availability across 115+ regions, and flexible document modeling. Start building AI apps faster, all in one place.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Ora2Pg!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

Perl

Related Categories

Perl Database Software

Registered

2025-07-25