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
Joined: Nov 22, 2008
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.