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 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.
Release Notes: This release adds multi-processing support to export data in parallel mode at full speed, which allows a speed improvement during data import by more than ten times. Multiprocessing capabilities allow Ora2Pg to be closer than the speed of an ETL. There's also a new export type to generate Kettle XML transformation files to be used with Kettle for data import. A lot of work has been done for speed improvement to scan Oracle databases with huge numbers of objects.
Release Notes: This release adds an HTML report for migration cost assessment and some bugfixes.
Release Notes: This is the first version of the 10.x series that is a major release. Overall numerous improvements and bugfixes. A new export type, SHOW_REPORT, will output a report of all objects contained in your Oracle database and some comments on how they will be exported. With this report, you can use a new directive ESTIMATE_COST to ask to Ora2Pg to evaluate the database migration cost in terms of man-days. There's also another new configuration directive EXTERNAL_TO_FDW (disabled by default) to permit the export of all Oracle external tables as file_fdw foreign tables.