Different data tranfer methods available to move data from on-prem database to Cloud database

RM 1 Reputation point
2022-11-19T06:45:50.533+00:00

Hello,

i have a use case to transfer data from on-prem MS SQL Database to Cloud MS SQL Database. After the first transfer, we need to move delta data and merge.

Please do suggest different options that i have to make this work? thanks in advance

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,340 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Samy Abdul 3,366 Reputation points
    2022-11-19T07:38:00.767+00:00

    Hi @RM , the generic approach for delta load is to have a delta table which captures

    updated row by last updated time stamp, and have a store procedure to update these

    time stamps. This is a good playlist for MS SQL ,please go through it :

    https://www.youtube.com/playlist?list=PLk7ap2pPJZBjSttwd4GT3Rc9HPzIUPKbM Thanks