Noumea, New Caledonia - September 27th, 2018 **Ora2Pg 19.1 released**
Version 19.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 during the last month and add support to PostgreSQL 11 HASH partitioning. It also adds some new features and configuration directives: * Add export of default partition and default sub partition. * Add export of HASH partition type. * Add support of stored procedure object. * Add replacement of NLSORT in indexes or queries. For example: CREATE INDEX test_idx ON emp (NLSSORT(emp_name, 'NLS_SORT=GERMAN')); is translated into CREATE INDEX test_idx ON emp ((emp_name collate "german")); The collation still need to be adapted, here probably "de_DE". NLSSORT() in ORDER BY clause are also translated. * Prevent duplicate index with primary key on partition to be exported. * PostgreSQL native partitioning does not allow direct import of data into already attached partitions. We now force direct import into main table but we keep Oracle export of data from individual This release also adds two new command line options: * --oracle_speed: use to know at which speed Oracle is able to send data. No data will be processed or written written * --ora2pg_speed: use to know at which speed Ora2Pg is able to send transformed data. Nothing will be written Use it for debugging purpose. They are useful to see Oracle speed to send data and at what speed Ora2Pg is processing the data without reaching disk or direct import into PostgreSQL. Two new configuration directive has been added: * PG_SUPPORTS_PROCEDURE : PostgreSQL v11 adds support to stored procedure objects. Disabled by default. * PARALLEL_MIN_ROWS: set the minimum number of tuples in a table before calling Oracle's parallel mode during data export. Default to 100000 rows. Note that PG_SUPPORTS_PARTITION and PG_SUPPORTS_IDENTITY are now enabled by default to use PostgreSQL declarative partitioning and identity column instead of serial data type. 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://www.ora2pg.com/ - 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 license. Docs, Download & Support at http://www.ora2pg.com/ -- Gilles Darold http://www.darold.net/