Visual Studio Toolbox: Database DevOps with Redgate ReadyRoll
In this first of two episodes, I am joined by Steve Jones to discuss how you can use the Redgate Data Tools that are included in Visual Studio Enterprise 2017 to extend DevOps practices to SQL Server and Azure SQL databases.
In this episode, Steve demonstrates the migrations-based approach used by ReadyRoll, which generates numerically ordered SQL migration scripts that sit inside your project and takes your schema from one version to the next. You can add them to version control, use them to build and release, and automate database and application deployments, all in one process.
Steve shows now only how to generate the migration scripts, but also how to incorporate them into a CI/CD pipeline using Visual Studio Team Services.