Re: Oracle to Postgres conversion suggestions?

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(at)hexack(dot)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(dot)kirkwood(at)catalyst(dot)net(dot)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
>
>
>