Skip to content

gwalkey/Azure-SQL-DevOps

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 

Repository files navigation

Azure-SQL-DevOps

Azure Devops For SQL contains Code Repos, Build and Release PIpelines and Scrum Boards

Setup Requirements

  • 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

Build Pipeline

  • Connect your Repo
  • Find your Solution
  • Configure MSBuild
  • Copy dacpac file to staging folder as an Artifact
  • On-Prem Build Agents

Release Pipeline

  • 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

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published