Postgres Pro
Downloads
Home   >   mailing lists

Re: migration tool - Mailing list pgsql-admin

From Venkata B Nagothi
Subject Re: migration tool
Date
Msg-id CAEyp7J_iqHTRFtmmBUFKRxOkyx2QPyzm7cYrrcgR9FxCbXLSEg@mail.gmail.com
Whole thread Raw
In response to migration tool  (Dhandapani Shanmugam <postgresql95@gmail.com>)
Responses Re: migration tool  (Dhandapani Shanmugam <postgresql95@gmail.com>)
List pgsql-admin
Tree view
 
On Thu, Oct 6, 2016 at 12:12 AM, Dhandapani Shanmugam <postgresql95@gmail.com> 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 N

Database Consultant/Architect

pgsql-admin by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: (Oracle to Postgres) migration tool
Next
From: Dhandapani Shanmugam
Date:
Subject: Re: migration tool