Grenoble, France - October 12th, 2020
Version 21.0 of Ora2Pg, a free and reliable tool used to migrate an Oracle database to PostgreSQL, has been officially released and is publicly available for download.
This release fix several issues reported since last release and adds several new features and improvements.
-b | --binpath DIRto set the full path to directory where the ora2pg binary stays. Might be useful only on Windows OS.
-r | --relativecommand line option and
PSQL_RELATIVE_PATHconfiguration directive. By default Ora2Pg use
\ipsql command to execute generated SQL files if you want to use a relative path following the script execution file enabling this option will use
\ir. See psql help for more information.
NO_VIEW_ORDERINGby default Ora2Pg try to order views to avoid error at import time with nested views. With a huge number of views this can take a very long time, you can bypass this ordering by enabling this directive.
NO_FUNCTION_METADATA: force Ora2Pg to not look for function declaration. This will prevent Ora2Pg to rewrite function replacement call if needed. Do not enable it unless looking forward at function breaks other export.
LOB_CHUNK_SIZE: see explanation in the new features and improvement list about BLOB/CLOB export speed improvement.
ALTERNATIVE_QUOTING_REGEXP: to support the Alternative Quoting Mechanism ('Q' or 'q') for String Literals set the regexp with the text capture to use to extract the text part. The value of this directive can be a list of regexp separated by a semi colon. The capture part is mandatory in each regexp if you want to restore the string constant.
NO_LOB_LOCATORis now 1 to benefit from
COMPILE_SCHEMAset to 1) by default to speed up DDL extraction.
For a complete list of change see https://github.com/darold/ora2pg/blob/master/changelog
Thanks to all contributors, they are all cited in the changelog file.
Global Temporary Tables for PostgreSQL extension: https://github.com/darold/pgtt
Ora2Pg is an easy and reliable tool to migrate from Oracle to PostgreSQL. It is developed since 2001 by Gilles Darold and can export most of the Oracle objects (table, view, materialized view, tablespace, sequence, indexes, trigger, grant, function, procedure, package, partition, data, blob, external table, etc.).
Ora2Pg works on any platform and is available under the GPL v3 license.
Docs, Download & Support at http://www.ora2pg.com/