This repository contains sample workflows for several scenarios related to SQL projects, including CI checks and deployments to multiple environments. Following this sample you'll be able to setup CI/CD workflows for database development and deployment, including:
- getting started from an existing database
- a CI check that validates all object references with
dotnet build - a CI check for SQL code quality with code analysis
- incorporating additional database objects in your build, such as system objects
- a deployment workflow that checks for deployment warnings
- a deployment workflow that updates a testing environment
- a deployment workflow that generates a script for review
The .NET Conf 2024 session Next-gen SQL projects with Microsoft.Build.Sql covered the topics in this repository for some background on establishing a database development lifecycle.
- .github: GitHub actions workflows
- ContosoOutdoors: SQL project folder
- Demos: walk-through of examples