Ora2Pg v18.4 has been released
От | Gilles Darold |
---|---|
Тема | Ora2Pg v18.4 has been released |
Дата | |
Msg-id | 571D3535.6050409@dalibo.com обсуждение исходный текст |
Список | pgsql-announce |
Paris, France - April 24th, 2016 **Ora2Pg 18.4 released** Version 18.4 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 is a maintenance release to fix several issues reported by users. There is also some major data export speed improvement thanks to the work of PostgreSQL Pro and a new RPM spec file provided by Devrim Gündüz to be able to build RPM package for Ora2Pg. Details of data export speed improvement are explained in the following article: http://blog.dalibo.com/2016/04/06/Ora2Pg_data_export_improvement.html There is a new configuration directive: * EMPTY_LOB_NULL: when enabled force empty_clob() and empty_blob() to be exported as NULL instead as empty string. Here is the complete list of other changes: - Put parenthesis around AT TIME ZONE expression - Add EMPTY_LOB_NULL directive to force empty_clob and empty_blob() to be exported as NULL instead as empty string. This might improve data export speed if you have lot of empty lob. Thanks to Alex Ignatov for the report. - Fix import_all.sh script to import grant and tablespace separately as postgres user and just after indexes and constraints creation. - Add parsing of tablespace from "alter table ... add constraint" with DDL input file. Thanks to Felipe Lavoura. - Remove --single-transaction in import_all.sh with TABLESPACE import. Thanks to Guillaume Lelarge for the report. - Fix Makefile.PL to used with latest spec file from Devrim Gündüz and following the advice of calbiston. - Update spec file to v17.4 and latest change to Makefile.PL - Replace ora2pg.spec by postgressql.org spec file by Devrim Gunduz. - Generate man page to avoids rpmbuild error. - Fix Windows install. Thanks to Lorena Figueredo for the report. - Remove "deferrability" call for mysql foreign keys. Thanks to Jean-Eric Cuendet for the report. - Fix issue in restoring foreign key for mysql data export. Thanks to Jean-Eric Cuendet for the report. - Remove connection test to PostgreSQL instance as postgres or any - Fix creation of configuration directory. - Fix Makefile to dissociate CONFDIR and DOCDIR from PREFIX or DESTDIR. Thanks to Stephane Schildknecht for the report. - Fix date_trunc+add_month replacement issue. Thanks to Lorena Figueredo for the report. - Do not replace configuration directory in scripts/ora2pg if this is a RPM build. Thanks to calbiston for the report. - Return empty bytea when a LOB is empty and not NULL. - Regular expressions and conditions checks improvement in method format_data_type() to make it a bit faster on huge tables. Thanks to Svetlana Shorina for the patch. - Fix INSERT using on the fly data import with boolean values. Thanks to jecuendet for the report. - Allow MySQL data type to be converted into boolean. Thanks to jecuendet for the report. - Fix export of BIT mysql data type into bit bit varying. Thanks to jecuendet for the report. - Fix call to escape_copy/escape_insert function call. As usual these also some bug fixes and Oracle to PostgreSQl conversion adjustments, see https://github.com/darold/ora2pg/blob/master/changelog for a complete list. 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
В списке pgsql-announce по дате отправления: