This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
netbeans + oracle
Oracle DB Link to SQL Server 2000
WebLogic 8 & Oracle10g - How's the performance on OS X?
Counter Increment
cant access my application