Configure CDC using SSIS and dump changes to Azure SQL Database
Author – Hitesh Srivastava, Associate Data Engineer This article describes how to configure CDC (Change Data Capture) using SSIS and dump the table from SQL Server 2016 hosted on Azure SQL-VM to Azure SQL Database by enabling CDC on the database and table at source i.e SQL Server 2016.. CDC (Change Data Capture) Change Data…