More Database DevOps with Redgate
2,309 views · Published 2 January 2018 · 16:12 · Indexed 27 September 2026
Channel: Microsoft Visual Studio · 2018 · Science & Technology
In this second of two episodes, Robert is joined by Steve Jones to discuss how you can use Redgate's DLM Automation tools to extend DevOps practices to SQL Server and Azure SQL databases. In this episode, Steve demonstrates the comparison-based approach used by SQL Source Control, which generates SQL scripts by comparing the state of version control with your development database. From with SQL Server Management Studio, you can add the changes to version control, and then use them in a CI/CD pipeline using Visual Studio Team Services. Steve shows now only how to capture database changes, but also use the TSQLT database unit testing framework with your database code, and incorporate testing into an automated database deployment process. Our database code is treated just like application code by making changes to a branch, creating a pull request, and then allowing VSTS to build, test, and release database code. Resources: - DLM Automation: https://www.red-gate.com/products/dlm/dlm-automation/ - SQL Source Control: https://www.red-gate.com/products/sql-development/sql-source-control/ - TSQLT: https://tsqlt.org/
More from this channel
-
1:49
Medical Workers Team Up with an Australian Software Company to Save Lives
-
11:12
In The Code 2.0: Building website UI with Michael Heggeseth
-
9:37
In The Code 2.0: Working on ASP.NET admin UI backend with David Paquette
-
7:45
How and Where to Acquire Apps
-
1:38
Age of Ascent from Illyriad Powered by Azure Service Fabric and ASP.NET
-
34:57
Mads Kristensen Extensions
-
17:28
Visual Studio Team Services (VSTS) Sprint 124 – what’s new?
-
31:31
Azure Functions: Less-Server and More Code