ora2pg

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.