Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle 10g to Postgresql 8.1

 
Ed Salvador
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?

Thanks,
Ed
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic