Version 17.3

2016 03 26 - v17.3

This release fix two regressions introduced in latest release.

• Fix major bug in data export. Thanks to Frederic Guiet for the report.
• Fix another regression with character data that was not escaped. Thanks
  to Frederic Guiet for the report.

Please, upgrade.

Version 17.2

This is a maintenance release to fix several issues reported in new
LOB extraction method. There is also some feature improvement:

• Allow NUMBER with precision to be replaced as boolean.
• Allow full relocation of Ora2Pg installation using for
  example: perl Makefile.PL DESTDIR=/opt/ora2pg

Here is the complete list of other changes:

• Allow NUMBER with precision to be replaced as boolean. Thanks
  to Silvan Auer for the report.
• Force empty LOB to be exported as NULL when NO_LOB_LOCATOR is
  activated to have the same behavior.
• Fix case where a LOB is NULL and ora2pg reports error :
  DBD::Oracle::db::ora_lob_read: locator is not of type OCILobLocatorPtr
  LOB initialised with EMPTY_CLOB() are also exported as NULL
  instead of \x
• Fix replacement with PERFORM after MINUS. Thanks to Stephane
  Tachoires for the report.
• Comment DBMS_OUTPUT.ENABLE calls. Thanks to Stephane Tachoire for
  the report.
• Fix wrong replacement of SELECT by PERFORM after EXCEPT. Thanks
  to Stephane Tachoire for the report.
• Apply ORACLE_COPIES automatic predicate on custom queries set with
  REPLACE_QUERY if possible. Thanks to pawelbs for the report.
• Fix install of ora2pg.conf file in /etc/ instead of /etc/ora2pg/.
  Thanks to pawelbs for the report.
• Add debug information before searching for custom type.
• Attempt to fix error "ORA-01002: fetch out of sequence" when exporting
  data from a table with user defined types and ORACLE_COPIES. Thanks to
  pawelbs and Alex Ignatov fir the report.
• Fix replacement of path to configuration file in scripts/ora2pg
• Remove report sample from documentation about migration assessment
  report and replace it with a href link. Fix comment about export of
  domain index.
• Always prefix table name with schema in Oracle row count, to prevent
  failure when the schema is not the connexion default.
• Add pattern TOAD_PLAN_.* to the internal table exclusion list.
• Fix modification of database owner search_path in import_all.sh auto
  generated script. Thanks to Stephane Tachoire for the report.

Version 17.1

This is a maintenance release to fix several issues reported in new
TEST action. There is also some feature improvement:

• Add OPTIONS (key 'true') on table FDW export when a column is detected as a primary key.
• Add DELETE configuration directive that allow a similar feature than the WHERE clause to replace TRUNCATE call by a "DELETE FROM table WHERE condition". This feature can be useful with regular "updates". Thanks to Sebastien Albert for the feature request.

Here is the complete list of other changes:

• Fix the counter of user defined types and sequences in TEST action
• Fix COPY import of data from column with user defined type with NULL value.
• Fix DBD::Pg segmentation fault with direct INSERT import from column with user defined type.
• Fix TEST action with multiple PG_SCHEMA export. Thanks to Michael Vitale for the report.
• Fix documentation about PG_SCHEMA

Version 17.0

This new major release adds a new action type TEST to obtain a count of all objects, primary keys, constraints, etc., at both sides, Oracle and PostgreSQL, to perform a diff between the two database and verify that everything have been well imported. It also fixes several issues reported by users.

A new ora2pg command line option have been added to ora2pg script:

• Add --count_rows command line option to perform a real row count on both side, Oracle and PostgreSQL, in TEST report.

See changelog for the complete list of changes and bugfixes:

Version 16.2

This release fixes several issues, is more accurate on migration
assessment report and adds some new ora2pg command line options:

• Add --pg_dsn, --pg_user and --pg_pwd to be able to set the
  connection to import directly into PostgreSQL at command line.
• Add -f option to script import_all.sh to force to not check
  user/database existing and skip their creation.

Potential backward compatibility issues:

• PG_SUPPORTS_CHECKOPTION is now enabled by default, you may want
  to migrate to PostgreSQL 9.4 or above.
• Remove modification of CLIENT_ENCODING in generic configuration
  file with --init_project, use the default instead.
• Remove modification of directive NLS_LANG to AMERICAN_AMERICA.UTF8
  in generic configuration file with --init_project, use the default
  instead.

See changelog the complete list of changes.