Updates, Inserts & Deletes/Oracle to SQL DTS Copy

• MegaDBA

  Hall of Fame

  Points: 3518

  More actions

  September 5, 2003 at 7:27 am

  #159779

  Currently I have a package that includes the following tasks:

  Truncate table

  Drop Indexes

  Copy Table (from Oracle Box to table in SQL)

  Rebuild Indexes

  It worked fine when the table was small but today we have over 50 million rows and it grows by about 175,000 rows per night.

  I would like to create a package that will only bring over updates, inserts & deletes. How can I do this using DTS?

  Thanks,

  
  

  Aurora

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  September 5, 2003 at 5:09 pm

  #472912

  It would be easier if you can identify the modified records in Oracle. If you can you could use a select statement to bring the data across.

  Steven

• MegaDBA

  Hall of Fame

  Points: 3518

  More actions

  September 16, 2003 at 3:23 pm

  #474513

  Steven, you are right. It would be most helpful to read the Oracle log, (Q-log)but wouldn't we need an app to do that?

  
  

  Aurora