This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com