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 >