From: michael@sqlexec.com <michael@sqlexec.com>
To: Stéphane KANSCHINE <stephane@hexack.fr>
Cc: 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 07:41:53 -0500
Message-ID: <58C29F11.10707@sqlexec.com> (raw)
In-Reply-To: <20170310085435.jmqt7utuwbss4p6n@office.hexack.fr>
References: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz>
<20170310085435.jmqt7utuwbss4p6n@office.hexack.fr>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
You might want to consider using oracle_fdw (thinking rolling migration)
in conjunction with Ora2pg (foreign keys, etc). Also, there are good
commercial tools out there like FullConvert.
Regards,
Michael Vitale
> Stéphane KANSCHINE <mailto:stephane@hexack.fr>
> Friday, March 10, 2017 3:54 AM
> 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
> Mark Kirkwood <mailto:mark.kirkwood@catalyst.net.nz>
> Friday, March 10, 2017 3:42 AM
> 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?
>
>
> details:
>
> - db size approx 5TB
>
> - blob and (Oracle) spatial datatypes involved
>
> - conversion and heterogeneous replication solutions needed
>
>
> Currently looking at Amazon schema conversion/data migration services
> but wondering if there are known good solutions out there!
>
>
> Cheers
>
>
> Mark
>
>
>
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michael@sqlexec.com, stephane@hexack.fr, mark.kirkwood@catalyst.net.nz
Subject: Re: Oracle to Postgres conversion suggestions?
In-Reply-To: <58C29F11.10707@sqlexec.com>
* 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