This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DevOps Flow Series, part 2 of 4 | |
Title: | |
Simple database deployments with GitHub and SSDT | |
Abstract: | |
For many of us, database deployments are time consuming, painful and risky. | |
The automated deployment of applications, and even servers, is now ubiquitous | |
- but most of us have not applied the same principles to our databases. | |
In this demo heavy session, we'll script out our database source code locally | |
using SSDT and commit it to GitHub. Then we'll build it automatically upon | |
commit, and deploy it at the click of a button with GitHub Actions. | |
We'll also discuss some of the common blockers and how they can be resolved. | |
For example, we'll discuss shared development databases, branching plans, testing and | |
masking production data for development. | |
You'll leave this session with a better understanding of how to deliver | |
working software more regularly and more reliably, enabling you to respond | |
better to business demands. | |
Simple Abstract: | |
100% demos: We will create a new public repository in GitHub, script out a | |
database using SSDT, and set up an automated GitHub Action to deploy our database. | |
More from the DevOps Flow series: | |
1. DevOps 101 for Data Folks: | |
https://gist.github.com/Alex-Yates/efef91357c6bd0dc1fbe63f2eb464f68 | |
2. Simple database deployments with GitHub, Azure DevOps Services and SSDT: | |
https://gist.github.com/Alex-Yates/43c7f4d51a651cd8b3dcdcb48843691f | |
3. Solving the dev database problem with GitHub, Docker and dbaclone: | |
https://gist.github.com/Alex-Yates/8125be587e58863ad35e0845ab6ffd5a | |
4. Zero downtime database deployments | |
https://gist.github.com/Alex-Yates/ac4c791bbd98eb3269f35db59cc30f88 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment