Incrementally copy data through Azure Data Factory using Change Tracking Approach from on-premise SQL Server to an Azure SQL database
Author – Gauri Pawse ( Sr. Cloud Engineer) Change Tracking is a lightweight solution in SQL Server database that provides an efficient change tracking mechanism for applications. It is a mechanism for tracking which rows have been inserted, updated, and deleted in tables monitored by change tracking. Using change tracking allows easy identification of new,…