Re: Oracle to PostgreSQL Migration - Need Information

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 08/07/2015 22:25, CS DBA a écrit :
>
>
> On 07/08/2015 02:20 PM, John R Pierce wrote:
>> On 7/8/2015 1:16 PM, dinesh kumar wrote:
>>> We recently done the similar migration for one of our customer.
>>> We used all opensource tools to achieve this migration
>>> process.
>>>
>>> We used Pentaho Data Integration tool for doing Online DB
>>> migration, which took minimal downtime with CDC{Change Data
>>> Capture} approach. Also, we used Ora2Pg tool to migrate the DB
>>> objects with some manual syntax modifications.
>>>
>>
>> thats the easy part.
>>
>> now what about the massive code base of pl/sql and triggers he
>> mentioned ?
>>
>>
>>
> Have you considered using ora2pg? http://ora2pg.darold.net/
>
> We've done several client migrations with it, quite successfully
>
>
>

ora2pg is definitely the tool you need. It can give you a total
migration estimated time (in man-day unit), with a call like

ora2pg -c ora2pg.conf -t SHOW_REPORT --dump_as_html --estimate_cost

You can check a sample report here: http://ora2pg.darold.net/report.html

- --
Julien Rouhaud
http://dalibo.com - http://dalibo.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)

iQEcBAEBAgAGBQJVnimjAAoJELGaJ8vfEpOqTKAH/0+uGEXUmGm6tfagpJqU7kB+
2c+jooW/MKokDcgifvmUTy+fKb8iDoF8CUffActFyX5YyrCFfb4Bjw9P6wuJfF6S
WXhzWXQ//AFiApqNPknfHWnYeqe4jJlLq2fHN7qCQvItEWuKFiHpWcEi1zVBPnMm
e6NLxePm0WzjpigbwhT2X0Ziena8CxxdencPQvO81clsR8Fgtq4B//6KQ3GEsIL2
aUtj4k+wBCmRywiMgiSYiQzLUXUp2HWOp6qLLYpwifr4BgY2X+CQNSHlAK2KXecf
fQ+rm3tyo5QEtMxHQPO/NUsl+zSIllZjPYG1Wa81RwsQpWKhNNB/+reDTSgC5ws=
=9pb/
-----END PGP SIGNATURE-----