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
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 |