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 DIR
to set the full path to directory where the ora2pg binary stays.
Might be useful only on Windows OS.-r | --relative
command line option and PSQL_RELATIVE_PATH
configuration directive. By default Ora2Pg use \i
psql 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_ORDERING
by 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_LOCATOR
is now 1 to benefit from LOB_CHUNK_SIZE
performances gain.COMPILE_SCHEMA
set 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.
Documentation: http://www.ora2pg.com/documentation.html
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/