Best way to extract large amounts data from Oracle

• Richard_Hadfield

  Ten Centuries

  Points: 1053

  More actions

  November 15, 2004 at 9:28 am

  #91526

  Currently loading data on a daily basis from Oracle to SQL Server I am using DTS and OLE DB for Oracle (45 Million rows) - runs overnight. 

  I was wondering if I could improve the performance of this extract by somehow reading the Oracle logs and updating my SQL tables.

  I am just investigating replication, is this the right way to go or is there a much better solution?

• Robert Stewart

  Hall of Fame

  Points: 3399

  More actions

  November 16, 2004 at 6:48 am

  #530262

  Are you moving all 45 million rows each night?

  If so, what you want to try is creating one or mor text files from Oracle and then using the bulk load in DTS to load your SQL Server tables.

  The best way is to apply a change/insert date time stamp on the Oracle side and pull only the changes or inserts for that day.