From: | Xiong He <iihero(at)qq(dot)com> |
---|---|
To: | Martin Gainty <mgainty(at)hotmail(dot)com>, jose(dot)soares <jose(dot)soares(at)sferacarta(dot)com>, pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: migrate from PostgreSQL to Oracle |
Date: | 2012-10-25 23:26:27 |
Message-ID: | tencent_555715A02AA0100E406CCAB6@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You can try this one:
http://code.google.com/p/hisql/
then JMyETL1.0.6
------------------
Thanks&Regards,
Xiong He
------------------ Original ------------------
From: "Martin Gainty"<mgainty(at)hotmail(dot)com>;
Date: Thu, Oct 25, 2012 10:18 PM
To: "jose.soares"<jose(dot)soares(at)sferacarta(dot)com>; "pgsql-general(at)postgresql(dot)org"<pgsql-general(at)postgresql(dot)org>;
Subject: Re: [GENERAL] migrate from PostgreSQL to Oracle
squirrel
http://www.squirrelsql.org/index.php?page=plugins
Saludos desde EEUU
Martin
______________________________________________
Porfavor ..no altere o interrumptir esta communicacion
> Date: Thu, 25 Oct 2012 15:50:08 +0200
> From: jose(dot)soares(at)sferacarta(dot)com
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] migrate from PostgreSQL to Oracle
>
> Hi all,
>
> I'm working with same db schema in PostgreSQL and Oracle,
> We mainly work in PostgreSQL but sometimes we need to copy schema and
> data from pg to oracle
> because some our customers want to use oracle instead of pg.
>
> Thus 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? something
> like the ora2pg script.
>
> thanks
>
> j
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Munro | 2012-10-26 04:55:27 | Re: migrating/spliting Postgres data directory on OpenIndiana |
Previous Message | Boris Epstein | 2012-10-25 18:46:05 | migrating/spliting Postgres data directory on OpenIndiana |