(Oracle to Postgres) migration tool

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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@xxxxxxxxxxxx
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux