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.
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.
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.
Release Notes: This release adds lots of changes, with five new configuration directives, a new export type MVIEW to export materialised views, and automatic detection and setting of Oracle character sets and PostgreSQL client encoding.