Thread: Oracle to Postgres migration open source tool

On 7/07/2011 9:55 PM, akp geek wrote:
> Hi all -
>
>                 Are there any open source tools available for migrating
> from oracle to postgres. We have 20 tables in oracles that we needed to
> get to postgres. Appreciate your help

One avenue you may wish to investigate is ETL tools like Talend. See Google.

EnterpriseDB offer an enhanced version of PostgreSQL with add-on Oracle
compatibility features to ease porting. This might be worth looking into.

Numerous companies offer consulting services for PostgreSQL, some of
which will cover Oracle migrations/conversions. See:
   http://www.postgresql.org/support/professional_support

As for specific oracle to PostgreSQL migration tools: Tried Google yet?

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088     Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/

Good truth migration between Oracle and PostgreSQL are not things
difficult:
Indicates that your database has:

Tables: 20
Shema:?
functions:?
Views:?

They need help to migrate ... Or what are you suggestions if you need a
tool that already does this task for you good people have a tool
interprisedb postgres'm not recommending eye but no way they already
have. : s


El jue, 07-07-2011 a las 09:55 -0400, akp geek escribió:
> We have 20 tables in oracles that we needed to get to postgres
--
______________________________________
Ing. Cesar A. Sulbaran P.
Junior Web Developer. (RUBY AND RUBY ON RAILS)
User 100% Open Sources.
Postgresql dba.
Kernel: 2.6.32-5--bigmen
http://www.google.com/profiles/cesulbaran

On Thu, Jul 07, 2011 at 09:55:45AM -0400, akp geek wrote:
> Hi all -
>
>                Are there any open source tools available for migrating from
> oracle to postgres. We have 20 tables in oracles that we needed to get to
> postgres. Appreciate your help

I have used ora2pg.  It was not seamless -- I had to do some whacking
around of the produced files, and I had a pretty good idea of what
changes were needed in the ora2pg tool to improve things, but I didn't
have time to implement them.  It was still a lot easier than trying to
do it all by hand.

A

--
Andrew Sullivan
ajs@crankycanuck.ca

On 07/07/2011 15:21, salah jubeh wrote:
 >
 > Hello,
 >
 > I do no have any experience with oracle, try to dump the oracle database in plain format and then try to execute the
DDLand DML statements. It might be cumbersome to fix all the errors you might get. 
 > But as an initial solution give it a shot.

I have migrated mysql, oracle, ingres and SqlSvr databases to Postgres and in pretty much all cases
around 30% of the activity has been application specific code changes or replacing Oracle
or SS7 specific optimisations with pg equivalents.

An example is the insert then update order issue on a unique keyed table.

The order does make a differenet in processing time and if within a stored procedure
I often find the procedure has to be redone to ensure it performs as expected.
Things like this tend to be missed by automated Ora->Pg toolsets.

I have never used the commercial Oracle "portability" layers but have heard good things about them.
If you have no procedural code or triggers then migration is usually a few days application review
work...

Jacqui

On Thu, Jul 07, 2011 at 12:01:56PM -0400, akp geek wrote:
> Thank you all for the responses. All we have is just table migrations, no
> procedures, triggers involved. I will try to do the migration using ora2pg.
> I downloaded it, while installing it I am getting an error. Will try to
> resolve that and proceed
>
> Writing
> /export/home/postgres/perl_5_10_0/lib/perl5/site_perl/5.10.0/sun4-solaris/auto/Ora2Pg/.packlist
> sh install_all.sh
> install_all.sh: test: argument expected
> gmake: *** [install_all] Error 1

It tries to test using a bunch of Oracle modules, and those modules
install with some sort of fake dependency (ISTR it was $ORACLE_HOME,
but it's a dim memory now -- there was something about installing
client-only libraries IIRC).  So you have to bodge up your environment
to get the Perl modules installed, then you need to _re_-bodge to make
sure you're actually pointing at the actual Oracle installation you
want to use.

A


--
Andrew Sullivan
ajs@crankycanuck.ca