File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle 10g to Postgresql 8.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle 10g to Postgresql 8.1" Watch "Oracle 10g to Postgresql 8.1" New topic

Oracle 10g to Postgresql 8.1

Ed Salvador

Joined: Oct 12, 2007
Posts: 1
I have 2 PC's on a network. PC1 and PC2.
PC1 has an Oracle 10g database. PC2 has a Postgresql 8.1 database.
I need to tranfer data on a regular basis, which will include Insert and Update, from PC1 (Oracle) to PC2 (Postgresql). There are about 7 tables from the Oracle database that need to be transferred. Some of the Oracle data will need to be reformatted into differnt field lengths and types.
I am currently using JRE 1.5, but can use JRE 1.6. This is on the Windows XP and Vista OS.
What is the best way to approach this ?

I agree. Here's the link:
subject: Oracle 10g to Postgresql 8.1
It's not a secret anymore!