Deploying Databases with Octopus

Database deployment tends to be the last thing automated with deployments. Deploying databases presents unique challenges and this course will plot your course towards database deployment, with hands-on examples of complex database deployments.
Course info
Level
Intermediate
Updated
Apr 24, 2018
Duration
1h 42m
Table of contents
Course Overview
Understanding Deployment and Synchronization
Introducing DbUp
Creating Database Deployment Projects in Octopus
Version Controlling Your Database Deployments
Creating Schema Update Projects with Octopus
Creating Data Update Projects with Octopus
Tackling Common Database Deployment Patterns
Where to Go from Here
Description
Course info
Level
Intermediate
Updated
Apr 24, 2018
Duration
1h 42m
Description

Deploying databases presents unique challenges and this course will plot your path towards database deployment, with hands-on examples of complex database deployments. In this course, Deploying Databases with Octopus, you will gain the ability to perform complex database synchronizations against your database servers. First, you will learn how to script common database changes. Next, you will discover how to execute and track these scripts using DbUp. Finally, you will explore how to execute these projects in Octopus. When you’re finished with this course, you will have the skills and knowledge of database deployment and Octopus needed to automate your complex database deployments.

About the author
About the author

Chris B. Behrens is a writer, speaker and software developer, specializing in DevOps. He has been a developer and architect for more than twenty years focusing on small to medium size companies and the development changes they face.

More from the author
Getting Started with D3
Beginner
2h 47m
Nov 29, 2018
More courses by Chris Behrens
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Chris B. Behrens, and welcome to my course, Deploying Databases with Octopus. I am an independent dev ops and software architect. Databases tend to be the last thing to be automated when it comes to deployment because they're usually the trickiest part. In this course we're going to take an in-depth look at the problems we face with database deployment. Some of the major topics we will cover include, scripting database changes, using DbUp for managing our scripts, using Octopus to deploy those scripts, and also some advanced database synchronization patterns. By the end of this course you'll know a good collection of the tools and techniques we use to manage DB deployment, when to use them, and why. Before beginning the course you should be familiar with Octopus Deploy, Microsoft Visual Studio, and SQL Server. I hope you'll join me on this journey to learn how to tame your databases with the Deploying Databases with Octopus course at Pluralsight.

Where to Go from Here
Security has been largely absent from our discussions because generally with security you set it up once, leave it alone, and never think about it. Stuff like that is better done by an admin one single time rather than scripting it, but if you've got 10 servers that need to have a new user or some other security tweak some scripting solution is going to come into play, so I'd like to give you a look at how to do that as we close out the course. Our company has been growing quickly for past two years, and management is getting the company ready for sale. A general call to document procedures, clean up the books, and tighten security has come down from management. Our Db Deployment security has always been pretty lose. We're just using a user with a DBO role, which is not as tight as it should be. What we need is a user with a DDL Admin role. The DDL stands for Data Definition Language. This is table creation, altering procedures, etcetera. A DDL admin has these permissions in SQL Server. These are the typical permissions you'll need to do Db Deployment.