Re: migrate from PostgreSQL to Oracle
- From: Igor Neyman <igor.neyman@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Wed, 24 Oct 2012 09:24:17 -0400
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@xxxxxxxxxxxx>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@xxxxxxxxxxxxxx>
> To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
> 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
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
