pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle to Postgres conversion suggestions?
4+ messages / 3 participants
[nested] [flat]
* Oracle to Postgres conversion suggestions?
@ 2017-03-10 08:42 Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2017-03-10 08:54 ` Re: Oracle to Postgres conversion suggestions? Stéphane KANSCHINE <stephane@hexack.fr>
0 siblings, 1 reply; 4+ messages in thread
From: Mark Kirkwood @ 2017-03-10 08:42 UTC (permalink / raw)
To: pgsql-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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Oracle to Postgres conversion suggestions?
2017-03-10 08:42 Oracle to Postgres conversion suggestions? Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
@ 2017-03-10 08:54 ` Stéphane KANSCHINE <stephane@hexack.fr>
2017-03-10 12:41 ` Re: Oracle to Postgres conversion suggestions? michael@sqlexec.com <michael@sqlexec.com>
2017-03-14 02:35 ` Re: Oracle to Postgres conversion suggestions? Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
0 siblings, 2 replies; 4+ messages in thread
From: Stéphane KANSCHINE @ 2017-03-10 08:54 UTC (permalink / raw)
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>; +Cc: 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@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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Oracle to Postgres conversion suggestions?
2017-03-10 08:42 Oracle to Postgres conversion suggestions? Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2017-03-10 08:54 ` Re: Oracle to Postgres conversion suggestions? Stéphane KANSCHINE <stephane@hexack.fr>
@ 2017-03-10 12:41 ` michael@sqlexec.com <michael@sqlexec.com>
1 sibling, 0 replies; 4+ messages in thread
From: michael@sqlexec.com @ 2017-03-10 12:41 UTC (permalink / raw)
To: Stéphane KANSCHINE <stephane@hexack.fr>; +Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>; pgsql-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
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Oracle to Postgres conversion suggestions?
2017-03-10 08:42 Oracle to Postgres conversion suggestions? Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2017-03-10 08:54 ` Re: Oracle to Postgres conversion suggestions? Stéphane KANSCHINE <stephane@hexack.fr>
@ 2017-03-14 02:35 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
1 sibling, 0 replies; 4+ messages in thread
From: Mark Kirkwood @ 2017-03-14 02:35 UTC (permalink / raw)
To: pgsql-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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-03-14 02:35 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-03-10 08:42 Oracle to Postgres conversion suggestions? Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2017-03-10 08:54 ` Stéphane KANSCHINE <stephane@hexack.fr>
2017-03-10 12:41 ` michael@sqlexec.com <michael@sqlexec.com>
2017-03-14 02:35 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
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