This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes Java in General and the fly likes Transfer db2 data to SAP's Oracle database Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Java » Java in General
Reply Bookmark "Transfer db2 data to SAP Watch "Transfer db2 data to SAP New topic
Author

Transfer db2 data to SAP's Oracle database

Naveen R R
Greenhorn

Joined: May 04, 2001
Posts: 20
posted
0
Quote
Hi,
We need to extract our Java intranet application's db2 data (only one table) and transfer it to SAP's oracle db. Any ideas as to how to do this? Do we need an interface?
Thank you,
Naveen
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
posted
0
Quote
You could write a program to do this in Java. You would need a JDBC driver for DB2 and one for Oracle. Assuming that you understand the structure of the two databases ( or if they are identical in structure, yeah, right! ) you could simply create two connections and read data from DB2 while writing it to Oracle.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Transfer db2 data to SAP's Oracle database
 
Similar Threads
project
Transfer db2 data to SAP's oracle database
How to configure DB2 for DBCS ?
to use db2 with wsad, we need to make db2 use JDBC 2?
New voucher from Oracle