Re: Oracle to Postgres conversion suggestions?

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

 



Thanks - yes (briefly). While it looks good (and appears to be able to do spatial data too)...the size of the source Oracle db means we need replication ability to catchup the changes that were being made while the migration was in progress.

In theory DMS can do this.

regards

Mark

On 10/03/17 21:54, Stéphane KANSCHINE wrote:
Le ven. 10 mars, vers 21:42, Mark Kirkwood exprimait :

Hi,

Hi,

I've been asked to help with one of these. I'm a bit wary, as I'm thinking
this is actually a really high risk endeavor. Any thoughts on toolkits that
might make this easy?

Do you look at ora2pg¹ ?

It's a good tool, that estimates the migration cost, migrate what it
can automatically (schema, constraints, data ) and let you do the hard
job : port your stored procedures and your applications if you didn't
use a good ORM.

¹ http://ora2pg.darold.net/

Regards




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