Database DevOps with Redgate ReadyRoll
4,616 views · Published 7 December 2017 · 28:04 · Indexed 14 November 2026
Channel: Microsoft Visual Studio · 2017 · Science & Technology
In this first of two episodes, Robert is 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. Resources: - Redgate Data Tools: https://www.red-gate.com/products/sql-development/entrypage/redgate-data-tools - ReadyRoll: https://www.red-gate.com/products/sql-development/entrypage/redgate-data-tools
More from this channel
-
3:21
More with Lori Lamkin - Our DevOps Journey - Microsoft Engineering Stories
-
2:51
More with James Phillips - Our DevOps Journey - Microsoft Engineering Stories
-
3:15
More with Buck Hodges - Our DevOps Journey - Microsoft Engineering Stories
-
3:03
More with Munil Shah - Our DevOps Journey - Microsoft Engineering Stories
-
25:59
SAP Fiori Mobile Apps, Visual Studio Tools for Apache Cordova, and Microsoft EMS
-
1:34
Novarum DX Transforms Global Health Initiatives using Native Xamarin Apps
-
1:49
Medical Workers Team Up with an Australian Software Company to Save Lives
-
1:29
Rich User Experience Keeps Apps Healthy at Boston Heart Diagnostics