RE: Oracle to Postgres-Licensed GUI tool

I'll second the recommendation. I used ora2pg for our migration. It's the 80% solution -- some of the data types weren't properly translated, but it's easy to go back, fix the appropriate script, and rerun that step. It saved us days of work for several terabytes of Oracle data.

>

-----------------------------
This message is intended only for the recipient(s) to which it is addressed and may contain information that is privileged and confidential. If you have received this message in error, please notify the sender immediately and delete all copies.
-----------------------------

-----Original Message-----
> From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
> Sent: Tuesday, November 20, 2018 12:18
> To: pgsql-admin(at)lists(dot)postgresql(dot)org
> Subject: Re: Oracle to Postgres-Licensed GUI tool
>
> soumik(dot)bhattacharjee(at)kpn(dot)com schrieb am 20.11.2018 um 19:10:
> > Anyone came across any Licensed GUI tool to migrate database schemas
> from Oracle to Postgres.
> >
> > +including Packages, Procedures etc..
> >
> > + Any idea of License costs if available.
>
> ora2pg is free and extremely powerful
>
> http://ora2pg.darold.net/
>
> It's non-GUI however - which I would prefer for a migration tool anyway as
> that is easier to automate
>