October 19, 2007 at 7:08 am
I am able to pull data from a progress database to a SQL DB. My question is; How do I set it up in such a way that I'm not dumping the compete table each and every time.
I'm in need to refreshing the data every 5 minutes and some of the progress tables are very large. Is there a way to do this using transactional methodology?
I also do not have any type of access to the Progress box.
Any suggestions will be welcome.
Thanks,
CY
October 19, 2007 at 8:21 am
Until we get the 2008 MERGE statement, you need to do three passes through the data, joining on the incoming data such that you do a batch of updates where the keys match, inserts where there are no keys on the existing data, and deletes where the existing data has keys but the incoming data does not.
It's complicated, but doable.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 19, 2007 at 8:24 am
Excellent. I'll give it a shot.
Thanks,
CY
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply