Re: oracle to postgresql conversion tool

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

2018-02-22 5:59 GMT+01:00 Marcin Giedz <marcin.giedz@xxxxxxxx>:

Hi, there are at least 5 tools I found on the PG list but could you recommend well tested, free one ? we need to migrate production 30GB oracle 11 db to postgres 9 and are looking for best approach. Of course if there is no free/open solution any commercial & recommended tool is always welcome.

Hard to say, what is the best approach. I used ora2pg on 60GB database with thousands views, thousands procedures without problems. It is not too fast, but just works

Regards

Pavel

Thank you

Marcin