Re: migrate from PostgreSQL to Oracle

From: Igor Neyman <igor.neyman_at_gmail.com>
Date: Wed, 24 Oct 2012 09:24:17 -0400
Message-ID: <CAJoeKmtOZH5t9uH70NzTHfGBzmvLCGbquftJhdtvRrM=Vb5p1w_at_mail.gmail.com>

Postgres is definitely capable of dumping data into flat (CSV) file, using COPY command.
Another option is direct connection between Oracle and Postgres using Heterogeneous Services (ODBC).
I used it successfully to do conversion, though in opposite direction: from Oracle to Postgres.

Regards,
Igor Neyman

On Wed, Oct 24, 2012 at 3:38 AM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:

> Jo,
> I'm not at all familiar with pg or pg_dump, however, if pg is capable of
> efficiently dumping data to flat files, my first suggestion would be to
> write a formatted text file, perhaps csv, and use Oracle external table to
> bulk load. Insert /*+ append */ into oracle_table select * from
> external_table would do it.
>
> Also, gives you opportunity to use nologging and do any necessary data
> transformations on the fly by adding functions on columns in select list,
> and finally, to do index builds (also nologging) after data loads.
>
> This approach should be pretty performant.
>
> Hope that helps,
>
> -Mark
> Sent from my Samsung Galaxy Note™, an AT&T LTE smartphone
>
>
>
> -------- Original message --------
> Subject: migrate from PostgreSQL to Oracle
> From: jo <jose.soares_at_sferacarta.com>
> To: ORACLE-L <oracle-l_at_freelists.org>
> CC: migrate from PostgreSQL to Oracle
>
>
> 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-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 24 2012 - 15:24:17 CEST