Updates, Inserts & Deletes/Oracle to SQL DTS Copy

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply