Postgres Pro
Downloads
Home   >   mailing lists

Thread: oracle to postgresql conversion tool

oracle to postgresql conversion tool

From
Marcin Giedz
Date:
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.

Thank you
Marcin

Re: oracle to postgresql conversion tool

From
Venkata B Nagothi
Date:

On Thu, Feb 22, 2018 at 3:59 PM, Marcin Giedz <marcin.giedz@arise.pl> wrote:
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.

Try using ora2pg which is a quite popular tool and a well tested one.

Regards,

Venkata B N
Database Consultant
 

Re: oracle to postgresql conversion tool

From
Pavel Stehule
Date:
Hi

2018-02-22 5:59 GMT+01:00 Marcin Giedz <marcin.giedz@arise.pl>:
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

Re: oracle to postgresql conversion tool

From
Pawan Sharma
Date:


On Feb 22, 2018 11:16 AM, "Pavel Stehule" <pavel.stehule@gmail.com> wrote:
Hi

2018-02-22 5:59 GMT+01:00 Marcin Giedz <marcin.giedz@arise.pl>:
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

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