Introduction CI-CD for Database

Houssem Dellai
A free video tutorial from Houssem Dellai
Engineer at Microsoft
4.4 instructor rating • 6 courses • 90,102 students

Learn more from the full course

Learn Azure DevOps CI/CD pipelines

Create CI/CD pipelines for Java, .NET, NodeJs, Docker, Terraform, Nuget, Xamarin, SQL Server and ARM templates

09:32:34 of on-demand video • Updated June 2021

  • What is DevOps and CI/CD
  • Creating CI/CD pipelines for Web, Mobile and Container apps
  • Including the Database into the pipelines
  • Configure deployment to Azure Cloud
  • Run unit, functional and load tests as part of the pipeline
  • Analyse source code using Sonar
  • Use Infrastructure as Code (IaC) from CI/CD with ARM templates
  • Use Configuration as Code (CaC) in Azure DevOps
  • Create Dev-Test-Prod environments
  • Secure the pipelines sensitive data
  • Use Infrastructure as Code (IaC) from CI/CD with Terraform
English [Auto] Let's learn how to create the CIC D pipeline for a sequel server database for applications that uses a database. We can either use entity framework to manage the database migrations but lots of users are actually using as dirty tools secret server that are tools. This means they use the database project type and Visual Studio are available also on SS M S equal server management studio because this project gives them more flexibility and more control over the scripts that will run on the database creating this UI and Cindy pipelines for the database now means building the. This project type this database project in order to generate the deck back file then deploying that DAC back from this 2D pipeline the deck black file is a package that contains the sequel scripts and also the stored procedures for the new schema of the database. So in each time we want to add a table that should go to and do a sequel script and the script will be included. And to this attack back. File so from our CIA pipeline will get that database project then we'll build it using s build task because it won't build with botnet so we'll be using a mis built so we generate the deck back file. Now later from this 2D pipeline will take that that back file from the artifact then we deploy it and 2 is equal Asia database or we can also connect to any sequel server database and to deploy that file to update the schema of that database.