Idempotent Data Patches in SQL Server: A Change Tracking Pattern for DACPAC Deployments

· by · in

If you deploy your SQL Server databases with SSDT or DACPACs via SqlPackage, you have probably run into this problem: the schema deployment is repeatable, but the data patches are not. SSDT handles CREATE TABLE,…