ora2pg

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.

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.

This release adds lots of code improvement, especially regarding case sensitivity. It adds a major feature by allowing data exportation of user-defined composite types. It fixes several bugs and adds some major changes.

This release supports automatic detection of case sensitivity on Oracle object names and two new configuration directives (CREATE_SCHEMA and PG_INTEGER_TYPE), shows a progress bar during data exportation, and fixes a lot of bugs.

This is a major release, mainly because it adds full support for Windows OSes with a new source tree and Makefile.PL, but also because it fixes long-standing issues with CLOB and BLOB exportation. Some default behaviors for timestamp and table/column exportation have changed.