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||POSIX Linux Unix Windows|
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.
Release Notes: This release fixes several major issues with migration cost assessment which were not addressed in previous release. Please upgrade.
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.
Release Notes: This release fixes several major issues, especially with direct import of data into PostgreSQL and the Windows port, which were both broken.
Release Notes: This release adds partition data speed improvement by exporting data directly from and into the partitioned tables. There's also some bugfixes for RAW or LONG RAW data exporting and PL/SQL to PL/PGSQL code rewriting.