Skip site navigation (1) Skip section navigation (2)

Ora2PG 10 : Evaluate your database migration costs

From: damien clochard <damien(at)dalibo(dot)info>
To: pgsql-announce(at)postgresql(dot)org
Subject: Ora2PG 10 : Evaluate your database migration costs
Date: 2012-12-19 08:52:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
Paris, december 19th 2012

Dalibo is proud to announce the release of Ora2Pg 10. This major release 
allows you to scan your legacy Oracle servers and estimate the migration 
costs. Ora2Pg also adds numerous improvements and enhancements such as 
the support of Oracle external tables.

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!

With the 10.x series, Ora2Pg adds a long-awaited feature : the migration 
assessment tool. When considering a data migration, Ora2Pg is now able 
to provide a report with a detailed cost estimation of the migration 
process. This report is generated in 2 steps. First, Ora2Pg scans every 
object contained in the Oracle database and analyze how they will be 
exported. Then, for each  database object, Ora2Pg will calculate the 
amount of work required (in man-days unit). This is helpful with very 
large Oracle databases and with PL/SQL stored procedures.

Gilles Darold, the project leader and main developer of Ora2Pg, 
explains: "Ora2Pg 10 is the first open source migration tool to provide 
global reports and migration cost estimations. More and more companies 
are considering moving from Oracle to PostgreSQL, and, with Ora2Pg, they 
can now forecast the return on investment of their migration process."

The migration assessment tool was developed by Dalibo in collaboration 
with Atos and the French DGFiP (the National Public Finance 
Administration). Dalibo would like to thank the developers who submitted 
patches and the users who reported bugs and feature requests, especially 
: Dominique Legendre, Philippe Lang, Sebastian Fischer, Dennis Spaag, 
Sorin Gheorghiu, and Siva Janamanchi. 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

Useful Links:

   * Website:
   * Download:
   * Development:
   * 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 

Ora2Pg works on any platform and is available under the GPL v3 licence.

Docs, Download & Support at


**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

pgsql-announce by date

Next:From: Jonathan S. KatzDate: 2012-12-19 17:24:35
Subject: PGDay NYC 2013 Registrations Open
Previous:From: Josh BerkusDate: 2012-12-18 19:38:17
Subject: PyPgDay Call For Presentations

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group