migrate from PostgreSQL to Oracle
From: jo <jose.soares_at_sferacarta.com>
Date: Wed, 24 Oct 2012 08:40:26 +0200
Message-ID: <50878D5A.2080707_at_sferacarta.com>
Hi all,
Date: Wed, 24 Oct 2012 08:40:26 +0200
Message-ID: <50878D5A.2080707_at_sferacarta.com>
Hi all,
I'm looking for some linux script to migrate from pg to oracle.
At the moment I dump data from pg using pg_dump in the format:
INSERT INTO table (columns) (values)
then I load it into the Oracle db using cx_Oracle
this procedure is so slow, and sometimes I have to edit and modify data
manually because some INSERT format aren't compatible.
Is there any interesting linux script to do this more easily?
thanks
j
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 24 2012 - 08:40:26 CEST