Change data capture in destination table

Posted by Sriharim under Sql Server on 7/3/2015 | Points: 10 | Views : 322 | Status : [Member] | Replies : 1
Data (Millions of records) from Source table to Destination table loaded. Now, the few records are updated in source table. How can i recognize and load/update the only updated data into destination table.



Posted by: Sheonarayan on: 7/8/2015 [Administrator] HonoraryPlatinum | Points: 25

Hi Sriharim,

When the source table is getting updated, are you maintaining any timestamp on those records? If not, any column that says that those records have been updated. If the timestamp column is being maintained then you can use that to filter records from source and update those records into your target database table.

If you need to update more than one column in the source database table, you will need to use cursor.

Read these posts -


Sheo Narayan

Sriharim, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response