(Oracle to Postgres) migration tool

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: postgresql95(at)gmail(dot)com
Subject: (Oracle to Postgres) migration tool
Date: 2016-10-05 13:45:28
Message-ID: 1f400672f9026980ed5fc952f3458e2f@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)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-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Venkata B Nagothi 2016-10-05 19:41:39 Re: migration tool
Previous Message Scott Mead 2016-10-05 13:37:19 Re: Cluster solution for Postgresql 9.5