Re: dump data from postgreSQL to Oracle

chunji08_at_gmail.com wrote:
> We have an existing project that is running by perl/cgi-bin, and
> postgreSQL is the backend DB server. And now we are trying to rewrite
> this project using java, and Oracle will be the backend db.

Good luck.

> We started
> the new one months ago, and now we need some real-time data to do some
> integration test. So the question is how to move some data in existing
> PostgreSQL table to Oracle table.
>
> I never did such think before, the only way I can think of is to dump
> the data from PostgresSQL table to a file and have Oracle reads it ?
> But what happen there is schema change between either other, or some
> datatype mis-match, etc .. ?
> I wand to know what is the Professional way to do such kind of work.
> Thanks.

I don't know about Professional with a capital P, but I see two options:

• Use pg_dump to extract the PostgreSQL database as SQL commands, modify the commands with a program or an editor to Oracle syntax and run the result as SQL script.
• Use COPY to extract the data as CVS file and load it with SQL*Loader into Oracle.

Yours,
Laurenz Albe Received on Tue Oct 03 2006 - 01:27:33 CDT