Slide 1

Slide 1 text

Alex Tercete @alextercete ReadyRoll Database deployment for .NET developers

Slide 2

Slide 2 text

Production

Slide 3

Slide 3 text

Developer 1 Production Developer 2

Slide 4

Slide 4 text

Developer 1 Production Developer 2 Developers have credentials for Production Doesn’t support multiple environments Generally a bad idea

Slide 5

Slide 5 text

Developer 1 Developer 2 Development Production DBA

Slide 6

Slide 6 text

Developer 1 Developer 2 Development Production DBA Developers don’t have credentials for Production Supports multiple environments Generated script might contain environment differences Non-repeatable

Slide 7

Slide 7 text

Production Application Developer 1 Developer 2

Slide 8

Slide 8 text

Production Application Developer 1 Developer 2 Developer 1 Developer 2 Developers only access to their local environments Repeatable DBA doesn’t have the chance to identify destructive changes Database lifecycle gets coupled to the application lifecycle

Slide 9

Slide 9 text

Developer 1 Developer 2 Development DBA Production

Slide 10

Slide 10 text

Developer 1 Developer 2 Development DBA Production Developer 1 Developer 2 Developer 1 Developer 2 Developers only access to their local environments Repeatable Predictable DBA has the chance to identify destructive changes

Slide 11

Slide 11 text

No content

Slide 12

Slide 12 text

Script 1 Script 2 Script 3 Development Script 1 Script 2 Production Script 1

Slide 13

Slide 13 text

Script 1 Script 2 Script 3 Development Script 1 Script 2 Script 3 Production Script 1

Slide 14

Slide 14 text

Script 1 Script 2 Script 3 Development Script 1 Script 2 Script 3 Production Script 1 Script 2 Script 3

Slide 15

Slide 15 text

Demo!

Slide 16

Slide 16 text

Workflow Edit DB Generate migration Verify DB ↔ project Is it good? Tweak migration Yes No

Slide 17

Slide 17 text

Alex Tercete @alextercete Thanks! speakerdeck.com/alextercete/readyroll-for-dotnet-developers

Slide 18

Slide 18 text

References Database Deployment Challenges simple-talk.com/sql/database-administration/database-deployment-challenges/ Deploying an Entity Framework Database into Production simple-talk.com/dotnet/net-framework/deploying-an-entity-framework-database-into-production/ ReadyRoll Frequently Asked Questions red-gate.com/products/sql-development/readyroll/faq ReadyRoll Sample github.com/red-gate/readyroll-sample

Slide 19

Slide 19 text

Credits Nimal Raj https://thenounproject.com/nimalraj/ Noe Araujo https://thenounproject.com/noearaujo/ Robert Bjurshagen https://thenounproject.com/robert.bjurshagen/ Rockicon https://thenounproject.com/rockicon/