From: "Greg Sabino Mullane" <greg@turnstep.com>
To: pgsql-admin@postgresql.org
CC: postgresql95@gmail.com
CC: postgresql95@gmail.com
Subject: (Oracle to Postgres) migration tool
In-Reply-To: 
 <CAAj4MFFryPovfbFw=zj6XTEts3kCX39P+KjW32-bDNQxxqf79w@mail.gmail.com>
Content-type: text/plain; charset=UTF-8
Date: Wed,  5 Oct 2016 13:45:28 -0000
Message-ID: <1f400672f9026980ed5fc952f3458e2f@biglumber.com>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin