Paris, France - January 13th, 2016
**Ora2Pg 16.2 released**
Version 16.2 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 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.
As usual there is also some bug fixes and Oracle to PostgreSQl
conversion adjustments, for a complete list see:
https://github.com/darold/ora2pg/blob/master/changelog
===== Links & Credits =====
Thanks to all contributors, they are all cited in the changelog file.
Useful Links:
- Website: http://ora2pg.darold.net/
- Download: http://sourceforge.net/projects/ora2pg/
- Development: https://github.com/darold/ora2pg
- Changelog: https://github.com/darold/ora2pg/blob/master/changelog
- Documentation: https://github.com/darold/ora2pg/blob/master/README
--------------
**About Ora2Pg**
Ora2Pg is an easy and reliable tool to migrate from Oracle to
PostgreSQL. It is developed since 2001 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 licence.
Docs, Download & Support at http://ora2pg.darold.net/
--------------
--
Gilles Darold
Consultant PostgreSQL
http://dalibo.com - http://dalibo.org
