Re: Oracle to Postgres migration open source tool

From: salah jubeh <s_jubeh(at)yahoo(dot)com>
To: casp <cesulbaran(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Cc: cesulbaran(at)gmail(dot)com
Subject: Re: Oracle to Postgres migration open source tool
Date: 2011-07-07 14:21:59
Message-ID: 1310048519.8728.YahooMailRC@web161513.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I do no have any experience with oracle, try to dump the oracle database in
plain format and then try to execute the DDL and DML statements. It might be
cumbersome to fix all the errors you might get. But as an initial solution give
it a shot.

Regards

________________________________
From: casp <cesulbaran(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: cesulbaran(at)gmail(dot)com
Sent: Thu, July 7, 2011 4:05:32 PM
Subject: Re: [GENERAL] Oracle to Postgres migration open source tool

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2011-07-07 14:35:17 Re: Latency problems with simple queries
Previous Message Simon Riggs 2011-07-07 14:21:11 Re: Streaming replication on 9.1-beta2 after pg_restore is very slow