Search code examples
oracle-databasedb2etldata-transfer

Transfer large amount of data from DB2 to Oracle?


I need every day to transfer large amounts of data (about several millions records) from db2 to oracle database. Could u suggest the best perfoming method to do that?


Solution

  • DB2 will allow you to select Oracle as a replication target. This is probably the most efficient and easiest way to do it every day, it also removes the "intermediate container" objection that you have.

    See this introduction (and more from the documentation online) for more.