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?