Thank You all for sharing the inputs. Rafael shared the open source migration tool http://www.omnidb.com.br which is awesome to use, Many Thanks.
On Thu, Oct 6, 2016 at 1:11 AM, Venkata B Nagothi <nag1010@xxxxxxxxx> wrote:
On Thu, Oct 6, 2016 at 12:12 AM, Dhandapani Shanmugam <postgresql95@xxxxxxxxx> wrote:Hi Gurus,We are planning to migrate from Oracle to PostgreSQL database. I need your help to identify the right tool to migrate the oracle data, I tried ora2pg but looks very complex. Can you suggest any GUI tools for postgreSQL migration please?Well, ora2pg is the widely used tool to migrate from Oracle to PostgreSQL. You can actually migrate most part of the database automatically, except PL/SQLs and VIEWs which you will have to re-write manually.As of i know there is NO other open-source tools like ora2pg available.Regards,Venkata B NDatabase Consultant/Architect
