Change data capture in destination table

Posted by Sriharim under Sql Server on 7/3/2015 | Points: 10 | Views : 765 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Mark as Answer if its helpful to you
---
Srihari

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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 - http://www.dotnetfunda.com/forums/show/11980/how-to-concatenate-using-cursor-in-sql-server Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Sriharim, if this helps please login to Mark As Answer. \| Alert Moderator

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 - http://www.dotnetfunda.com/forums/show/11980/how-to-concatenate-using-cursor-in-sql-server

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

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

Latest Posts