From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Oracle to Postgres conversion suggestions?
Date: Fri, 10 Mar 2017 21:42:57 +1300
Message-ID: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
--
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: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@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