From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: pgsql-admin@postgresql.org
Subject: Re: Oracle to Postgres conversion suggestions?
Date: Tue, 14 Mar 2017 15:35:00 +1300
Message-ID: <80113f69-b986-5da5-2034-76989aba55a2@catalyst.net.nz> (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>
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@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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz
Subject: Re: Oracle to Postgres conversion suggestions?
In-Reply-To: <80113f69-b986-5da5-2034-76989aba55a2@catalyst.net.nz>
* 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