Azure Devops For SQL contains Code Repos, Build and Release PIpelines and Scrum Boards
- Create a Development Project in your Organization
- Uploade your SQL Database Project to a Repo
- Create a Service Connection using your Resource Group to your SQL Server
- Create a Build Pipeline
- Create a Release Pipeline
- Make a Database design change and check it in
Devops can automate the updates to your live SQL Servers
- Connect your Repo
- Find your Solution
- Configure MSBuild
- Copy dacpac file to staging folder as an Artifact
- On-Prem Build Agents
- Add an Artifact
- Add Deployment tasks to a Stage
- Separate Dev/QA/Prod servers using stages
- Using KeyVault to hold your SQL admin passwords
- Configure CI/CD Triggers
- Assign Approvals and Notifications