Ora2PG 11 : Faster Oracle to PostgreSQL Migrations

Posted on 2013-04-10 by Dalibo

Paris, April 9th 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:

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.com