Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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:
Yours,
Laurenz Albe
Received on Tue Oct 03 2006 - 01:27:33 CDT
![]() |
![]() |