@rob_rich
#SQLintheCity
Red Gate

Automating Database Deployments on the Microsoft Stack


Rob Richardson

Software Craftsman and Microsoft MVP

 

@rob_rich

https://robrich.org/


our task:

Build a Database DevOps Pipeline


DevOps Pipeline

Customer Concern Task Tracking Developer Builds Feature Source Control CI Build Dev / Test Server Deploy Production Server Customer Value
Customer Concern Task Tracking Developer Builds Feature Source Control Build Server Dev/Test Deploy Production Customer Value

DevOps Pipeline

Developer Builds Feature Source Control CI Build Deploy Server
Developer Source
Control
Build
Server
Deploy Server

DevOps Pipeline

Visual Studio Git Team City Octopus Deploy SQL Server
Visual Studio Git Team City Octopus Deploy SQL Server

Demo

Switch to Demo

DevOps Pipeline

Visual Studio Git Team City Octopus Deploy SQL Server
Visual Studio Git Team City Octopus Deploy SQL Server