Visual Studio Toolbox: More Database DevOps with Redgate
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.