Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Server Continuous Database Delivery with Flyway

via Pluralsight

Overview

Delivering database changes pose a unique set of challenges that force many to treat database changes as a second class citizen when releasing software. You'll learn how to use Flyway to version changes to a SQL Server database, and how to leverage versioned changes from your code repository to get early feedback about potential problems, including how to simulate a production database update every time someone checks in a database change.

Continuous Delivery can dramatically decrease turn-around time between customer need and delivered software to fulfill that need. Combining discipline with the right practices and tools leads to early feedback about potential problems, a system of safety nets, the highest level of accountability, and an overall boost in confidence when releasing software. Delivering database changes poses a unique set of challenges that force many to treat database changes as a second class citizen when releasing software. This leads to delays and a lack of realizing the full potential of Continuous Delivery. In this course, you’ll learn the fundamentals to make managing database change a breeze and how to make it a first class citizen in your Continuous Delivery pipeline. You'll learn how to use Flyway to version changes to a SQL Server database. We will also cover how to leverage versioned changes from your code repository to get early feedback about potential problems, including how to simulate a production database update every time someone checks in a database change.

Syllabus

  • Continuous Database Delivery 38mins
  • Tracking Changes 57mins
  • Development Workflow 62mins
  • Reverse Engineering Dev DB Changes 44mins
  • Pulling Changes 32mins
  • Delivery Workflow 50mins
  • Transition Existing Databases 52mins
  • Rethinking How We Develop 47mins

Taught by

Wes Higbee

Reviews

4.5 rating at Pluralsight based on 62 ratings

Start your review of SQL Server Continuous Database Delivery with Flyway

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.