JEFF TAYLOR

How To Fully Automate Database Deployments

Jeff Taylor
Data/Software Architect
SQL Server Since SQL 6.5
20+ years working with Microsoft SQL Server
Contact: Jeff@ReviewMyDB.com, @reviewmydb
Current Favorite Website: http://dbareactions.com

ABOUT ME

Questions

What is your current role?
Do you currently have Automation surrounding your database/app deployments? (If so, what do you use?)
How long does it currently take for your company to deploy a release?
How many employees are involved in a typical deployment?

PROBLEMS ENCOUNTERED

Scripts were manually created and appended to for deployments. (Which at times meant you touched the same object multiple times)
Databases between environments did not match 100%, so there were constant errors and fixes during deployments.
Deployments to Production would take 24-48 hours.
Database scripts would be consistently executed on the wrong server. (We had same database names on different servers)

AGENDA

Environment Layout
Demo: Setup Visual Studio Online & Source Control
Demo: Setup Octopus Deploy / Red Gate DLM
Demo: Red Gate SQL Compare
Demo: Setup Visual Studio Team Services Build
Demo: Connect All The Parts

Environment Layout

Demo:

Setup Visual Studio Online & Source Control

Licensing*

* I'm not Microsoft, but here is where I found this information.
https://www.visualstudio.com/team-services/pricing/
https://www.visualstudio.com/en-us/docs/setup-admin/team-services/buy-basic-access-add-team-services-users

5 users who get Basic features like version control, tools for Agile, Java, build, release management, and more
Unlimited Stakeholders who get more restricted features like working with your backlog, work items, and queries
Unlimited Visual Studio subscribers who also get Basic features, and in some cases, additional features with specific extensions like Test Manager

Demo:
Setup Octopus Deploy & Red Gate DLM Automation

Licensing*

Community edition - is free for small teams, even for commercial use. It allows you to deploy up to five projects to up to ten target machines, and is limited to five users. Simply download Octopus and start a 45-day trial. At the end of the trial you can choose to continue using the Community edition for free. Happy deployments

Professional - 20 users, 20 projects and 20 target machines.
Team - 60 users, 60 projects and 60 target machines.
Enterprise - Unlimited users, projects and target machines.
High Availability - Unlimited users, projects, target machines and multiple nodes. Learn more about High Availability.

*https://octopus.com/purchase