Re: Oracle to Postgres conversion suggestions?

From: Stéphane KANSCHINE <stephane(at)hexack(dot)fr>
To: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Oracle to Postgres conversion suggestions?
Date: 2017-03-10 08:54:35
Message-ID: 20170310085435.jmqt7utuwbss4p6n@office.hexack.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
--
Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./
@ stephane(at)hexack(dot)fr
 +33 6 64 31 72 52

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message michael@sqlexec.com 2017-03-10 12:41:53 Re: Oracle to Postgres conversion suggestions?
Previous Message Mark Kirkwood 2017-03-10 08:42:57 Oracle to Postgres conversion suggestions?