sql-database-projects
Builds and publishes a SQL database project against Azure SQL Database: the SDK-style .sqlproj on Microsoft.Build.Sql, the target platform that decides what the build actually validates, pre and post deployment scripts, the refactorlog, and code analysis. Use when a user asks to "create a SQL database project", "build a dacpac", "publish a dacpac to Azure SQL", "add a post-deployment script", "rename a column without losing its data", or "turn on code analysis", and reports "the build passed but the publish failed", "the deploy said success and the data is gone", or "the post-deployment script failed and the table already changed". Covers what dotnet build does not check, what SqlPackage does with a mismatched target platform, and which publish options change data rather than schema. github-actions-for-sql owns the pipeline, schema-migrations-safely the change doctrine.
Pinned to revision eeb1c6867c2d, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/sql-database-projects/SKILL.md
- skills/sql-database-projects/references/target-platform-and-refactorlog-runs.md
Every link opens the file at its source, pinned to the revision this page describes.