Paris, France - Febuary 17th, 2017
**Ora2Pg 18.1 released**
Version 18.1 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 on outer join translation
thanks to the help of Pavel Stehule and reapply the commit on virtual
column export that was accidentally removed from v18.0. It also adds
several new features:
* Remove CHECK constraints for columns converted into boolean using
REPLACE_AS_BOOLEAN column.
* Oracle function are now marked as stable by default as they can
not modify data.
Two new configuration directives have been added:
* DATE_FUNCTION_REWRITE: by default Ora2pg rewrite add_month(),
add_year() and date_trunc() functions set it to 0 to force Ora2Pg
to not translate those functions if translated code is broken.
* GRANT_OBJECT: when exporting GRANT you can now specify a comma
separated list of objects which privileges must be exported.
Default is to export privileges for all objects. For example
set it to TABLE if you just want to export privilege on tables.
and a new command line option:
* Add -g | --grant_object command line option to ora2pg to be able
to extract privilege from the given object type. See possible values
with GRANT_OBJECT configuration directive.
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.
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 and external
table).
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
