(Oracle to Postgres) migration tool - Mailing list pgsql-admin

From Greg Sabino Mullane
Subject (Oracle to Postgres) migration tool
Date
Msg-id 1f400672f9026980ed5fc952f3458e2f@biglumber.com
Whole thread Raw
In response to migration tool  (Dhandapani Shanmugam <postgresql95@gmail.com>)
List pgsql-admin
-----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-----




pgsql-admin by date:

Previous
From: Scott Mead
Date:
Subject: Re: Cluster solution for Postgresql 9.5
Next
From: Venkata B Nagothi
Date:
Subject: Re: migration tool