SQL projects DevOps sample

Browse code

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.

Contents

• .github: GitHub actions workflows
• ContosoOutdoors: SQL project folder
• Demos: walk-through of examples

Demo walk-through

• Get started
• CI checks
• Architecture options
• Deploy to multiple environments

Resources

• .NET Conf 2024 slides
• SQL projects documentation
• DacFx GitHub repository