Ora2PG 11 : Faster Oracle to PostgreSQL Migrations

Paris, April 10th 2013

Dalibo is proud to announce the release of Ora2Pg 11.1. This major
release adds support to multiprocessing so that you can now export data
in parallel mode. Importing data from an Oracle database is now ten
times faster. With this new feature, Ora2Pg performances are closer to
the ones you'd get with any ETL.

Since 2001, Ora2Pg is the best solution to migrate data from Oracle to
PostgreSQL and is used by thousands of companies around the world to
switch from the most expensive proprietary RDBMS to the most advanced
Open Source RDBMS!

Ora2pg 11.1 also brings important improvements :

* You can now generate XML transformation files for Kettle (see
http://kettle.pentaho.com/)
* Faster scan of Oracle databases containing huge number of objects.
* Faster partition data export with direct import to tables partition.
* Bug fixes on RAW or LONG RAW data export.
* PL/SQL to PL/PGSQL code rewrite.

Gilles Darold, the project leader and main developer of Ora2Pg,
explains: “The development of ora2pg is really fast because more and
more companies are moving from Oracle to PostgreSQL. This new version
brings speed improvements to migrate multi-terabyte databases faster.
For most users, lowering the migration time is critical because it means
less downtime during the switch from Oracle to PostgreSQL.”

These performance enhancements were developed by Dalibo in collaboration
with Photobox, Europe's largest online photo processing service and
Bouygues Telecom, a major mobile network operator and ISP in France.

Dalibo would like to thank the developers who submitted patches and the
users who reported bugs and feature requests, especially : Dominique
Fourdrinoy, Ludovic Penet, Thomas Ogrisegg, Alex Delianis, Pierre-Marie
Petit and mrojasaquino. Ora2Pg is an open project. Any contribution to
build a better tool is welcomed. You just have to send your ideas,
features requests, or patches using the GitHub tools at
https://github.com/darold/ora2pg.

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

-----------------------------

About Ora2Pg :

Ora2Pg is an easy and reliable tool to migrate data from Oracle to
PostgreSQL. It is developed since 2001 by Gilles Darold, also author of
pgBadger, a PostgreSQL performance tool. Ora2Pg can export most of the
Oracle objects (table, 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/

-----------------------------

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support,
trainings and consulting to its customers since 2005. The company
contributes to the PostgreSQL community in various ways, including :
code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.io