Обсуждение: migration tool
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?
-Dhandapani
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > 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? Such a migration is by its nature complex. You are unlikely to find any one-click GUI tools to completely automate the migration - it will take a lot of testing, tweaking, and DBA know-how, althought tools like ora2pg are a great start can get you 95% of the way there. Take a look at the tools at the bottom of this must-read page: https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201610050938 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAlf1A+oACgkQvJuQZxSWSsgKHACePZCMDAQib1vBYDPfhNCwG0yE IdIAoJAWPhjl3Qp3GhBO7MndZbaa0f9h =Zvsr -----END PGP SIGNATURE-----
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
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@gmail.com> wrote:
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 NDatabase Consultant/Architect