On Feb 22, 2018 11:16 AM, "Pavel Stehule" <pavel.stehule@xxxxxxxxx> wrote:
Hi2018-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 worksRegardsPavelThank youMarcin
Hi Pavel,
You can easily migrate table,view,index's,mview ..etc using any migration tool, but you need to work some how on plsql objects like procedure, trigger, function.etc