ReadyRoll for DotNet developers

Database deployments made easy!

References:
- https://www.simple-talk.com/sql/database-administration/database-deployment-challenges/
- https://www.simple-talk.com/dotnet/net-framework/deploying-an-entity-framework-database-into-production/
- http://www.red-gate.com/products/sql-development/readyroll/faq
- https://github.com/red-gate/readyroll-sample

Transcript

1. Alex Tercete @alextercete ReadyRoll Database deployment for .NET developers
2. Production
3. Developer 1 Production Developer 2
4. Developer 1 Production Developer 2 Developers have credentials for Production Doesn’t support multiple environments Generally a bad idea
5. Developer 1 Developer 2 Development Production DBA
6. 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
7. Production Application Developer 1 Developer 2
8. 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
9. Developer 1 Developer 2 Development DBA Production
10. 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
12. Script 1 Script 2 Script 3 Development Script 1 Script 2 Production Script 1
13. Script 1 Script 2 Script 3 Development Script 1 Script 2 Script 3 Production Script 1
14. Script 1 Script 2 Script 3 Development Script 1 Script 2 Script 3 Production Script 1 Script 2 Script 3
15. Demo!
16. Workflow Edit DB Generate migration Verify DB ↔ project Is it good? Tweak migration Yes No
17. Alex Tercete @alextercete Thanks! speakerdeck.com/alextercete/readyroll-for-dotnet-developers
18. 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
19. 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/