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*

• 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​

Demo:
Red Gate SQL Compare

Demo:
Setup Visual Studio Team Services Build

Demo:
Connect All The Parts

Environment Layout

Questions?

CONTACT

Email: Jeff@ReviewMyDB.com

Twitter: @ReviewMyDB

RESOURCES

https://www.visualstudio.com/

https://octopus.com/

http://www.red-gate.com/