Blog

Managing Schema Changes: SQL Database Projects and DACPAC (State-Based) vs DbUp and Flyway (Migration-Based)

A state-based tool doesn't know about renames: after a column was renamed in the project, SqlPackage tried to drop and re-add it and was stopped only by BlockOnPossibleDataLoss; with a refactorlog it generated sp_rename. DACPACs with Microsoft.Build.Sql 2.3.0, deploy scripts and DeployReport, a hand-added index dropped by default, a CHECK definition that causes a false diff, and a changed migration DbUp misses and Flyway catches by checksum.