Database

Shipping database changes with SSDT and DACPAC

Published note: SSDT as source of truth—no images, plain structured HTML.

AppHubDb ships as an SSDT database project. Build emits a DACPAC you can publish to SQL Server or Azure SQL for repeatable environments.

Checklist

  1. Build the .sqlproj in Release.
  2. Run post-deploy for idempotent demo data.
  3. Run smoke tests on a fresh database.
Keep schema in SSDT; avoid competing EF migrations unless you intentionally change ownership.