Postgres Pro
Downloads
Home   >   mailing lists

Re: oracle to postgresql conversion tool - Mailing list pgsql-general

From Pawan Sharma
Subject Re: oracle to postgresql conversion tool
Date
Msg-id CAKqG8NVWCv8vgaptxD5C_4fx3gRL_k9M7+JN4ensgx-MM_A8Sw@mail.gmail.com
Whole thread Raw
In response to Re: oracle to postgresql conversion tool  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view


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 





pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: oracle to postgresql conversion tool
Next
From: Michael Paquier
Date:
Subject: Re: initdb when data/ folder has mount points