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-----
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 |