October 4, 2002 at 12:00 pm
Greetings. I need to be able to copy data from an Informix DB to a SQL DB on a daily basis. Only copying the "new" data from Informix. I have used DTS to copy the existing data and structure. I just need to setup some sort of procedure to append SQL with the data from the previous day. (I'm a newbie, if you haven't guess it by now... )
Thanks for your help!!
t
October 4, 2002 at 7:03 pm
We do this will an Oracle database. What we do is in our our DTS package we define the Oracle side with a query to qurery the last modified date column back 2 days from the current day and pull to a temp (permanent) table, then after that we run a sp to find the differences that do exist and move them in. Something similar depending on how you can identify the missing data should work for you.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 16, 2002 at 2:27 pm
Antares686,
I am trying to achieve the same thing.
I have built a package where my source is Oracle and Destination is SQL DB. In this package while transformation I have written functions in Active X script, also I am calling my lookups queries in Active X Script.
Since I have lots of records. I am loading the data in chunks. The very first
time I am loading 3months data starting today(ex if today is 12/1/2002 then 3 months data=from 9/1/2002 - 12/1/2002) and then 3 months before that(which will be from 6/1/2002 - 9/1/2002) plus modified data in first 3 months (from 9/1/2002 - 12/1/2002).
I am not sure how should I achieve this since I want to do an incremental update for
already loaded data in a table?
Also, I am adding many additional columns in my destination table which contains values based on my Active X scripts so its not a direct copy of source.
Thanks,
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply