|
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.soares@xxxxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general |
