Idempotent Data Patches in SQL Server: A Change Tracking Pattern for DACPAC Deployments
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,…
SqlPackage, Synonyms, and the Third-Party Database Problem
You’ve got a SQL Server database that talks to a third-party database via synonyms. The third-party vendor lets customers customize their schema. The table names differ across environments. You use SSDT and SqlPackage for deployments….