Projects / ora2pg


Ora2Pg is a Perl module to export an Oracle database schema to a PostgreSQL compatible schema. It connects your Oracle database, extracts its structure, and generates an SQL script that you can load into your PostgreSQL database. It dumps the database schema (tables, views, sequences, indexes, grants) with primary, unique, and foreign keys into PostgreSQL syntax without editing the SQL code generated. It also dump Oracle data into PostgreSQL DB as online process or into a file. You can choose what columns can be exported for each table.

Operating Systems

Recent releases

  •  28 Jan 2014 16:44

    Release Notes: This minor release is mainly a maintenance release with some minor bugfixes and a new configuration directive, INDEXES_SUFFIX, to append a suffix to index names.

    •  22 Oct 2013 11:48

      Release Notes: This release fixes many issues and adds three new features. Using the REORDERING_COLUMNS directive, you will be able to reorder columns to minimized the footprint on disk so that more rows fit on a data page. The PG_SUPPORTS_MVIEW allow the export of materialized view with native PostgreSQL 9.3 syntax. The USE_TABLESPACE variable can be used to export objects using their original tablespace.

      •  28 May 2013 14:10

        Release Notes: This release fixes several major issues with migration cost assessment which were not addressed in previous release. Please upgrade.

        •  27 May 2013 15:26

          Release Notes: This release fixes several major issues with migration cost assessment, especially with stored procedures with lot of lines or if you have lot of comments in that code. You may want to run your database evaluation again, as the estimated times can be up to three times lower on huge PL/SQL code.

          •  01 May 2013 07:14

            Release Notes: This release fixes several major issues, especially with direct import of data into PostgreSQL and the Windows port, which were both broken.


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.