RE: Oracle to Postgres-Licensed GUI tool - Mailing list pgsql-admin

From Erwin Fritz
Subject RE: Oracle to Postgres-Licensed GUI tool
Date
Msg-id 9E6E27BCA0E8EE478089F158D73AF936AA4B6A0D@Exch10-Mailbox.corp.gljpc.com
Whole thread Raw
In response to Re: Oracle to Postgres-Licensed GUI tool  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-admin
I'll second the recommendation. I used ora2pg for our migration. It's the 80% solution -- some of the data types
weren'tproperly translated, but it's easy to go back, fix the appropriate script, and rerun that step. It saved us days
ofwork 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
privilegedand confidential. If you have received this message in error, please notify the sender immediately and delete
allcopies.
 
-----------------------------

-----Original Message-----
> From: Thomas Kellerer <spam_eater@gmx.net>
> Sent: Tuesday, November 20, 2018 12:18
> To: pgsql-admin@lists.postgresql.org
> Subject: Re: Oracle to Postgres-Licensed GUI tool
>
> soumik.bhattacharjee@kpn.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
>


Attachment

pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC inpg_wal "No space left on device"
Next
From: bhanu prabhakar
Date:
Subject: Trigger to create automated range partition table