From: Stéphane KANSCHINE <stephane@hexack.fr>
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Oracle to Postgres conversion suggestions?
Date: Fri, 10 Mar 2017 09:54:35 +0100
Message-ID: <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr> (raw)
In-Reply-To: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz>
References: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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@hexack.fr
+33 6 64 31 72 52
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: stephane@hexack.fr, mark.kirkwood@catalyst.net.nz
Subject: Re: Oracle to Postgres conversion suggestions?
In-Reply-To: <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr>
References: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz> <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox