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@xxxxxxx> > Sent: Tuesday, November 20, 2018 12:18 > To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx > Subject: Re: Oracle to Postgres-Licensed GUI tool > > soumik.bhattacharjee@xxxxxxx 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 >
BEGIN:VCARD VERSION:2.1 N:Fritz;Erwin;;; ORG:GLJ Petroleum Consultants TITLE:IS Operations Manager EMAIL;PREF;internet:efritz@xxxxxxxxx TEL;VOICE;WORK:+1 (403) 266-9570 TEL;FAX;WORK:+1 (403) 262-1855 ADR;WORK;PREF;ENCODING=QUOTED-PRINTABLE:;;Suite 4100, 400 Third Ave SW;Calgary;Alberta;T2P 4H2;Canada FN:Erwin Fritz REV:20181120T210611Z END:VCARD
