Transcript Grant_Fritchey_AutomatedDatabaseDeployment_Rallyx

Automate Your Database
Deployments
Grant Fritchey
Product Evangelist – Redgate Software
Get in touch
Grant Fritchey
scarydba.com
[email protected]
@gfritchey
Continuous
Integration
Development
Production
Testing
Database development
and change management
Operations
QA / Test / Pre-production
Continuous
integration
Build
Test
Trigger
Source
control
Publish
Sync
ALTER
TABLE
foo…
Deployment
script
Release management
Artifact
repository
Development
Continuous delivery for databases
Review,
Backup
& deploy
Production
Continuous
Integration
Development
Testing
Production
In this presentation
QA / Test / Pre-production
Continuous
integration
Build
Test
Trigger
Source
control
Publish
Sync
ALTER
TABLE
foo…
Deployment
script
Release management
Artifact
repository
Development
Continuous delivery for databases
Review,
Backup
& deploy
Production
patterns and practices
•
the advantages
•
the challenges
what it is and isn’t
Common misconception:
Continuous delivery = Continuous deployment
But in fact:
Continuous delivery means making sure your
database changes are always production-ready.
Release pipeline
Test
Development
Production
Continuous Integration
Continuous delivery
Continuous deployment
Approval
gate
deployment pipeline
SOURCE
CONTINUOUS
AUTOMATED
AUTOMATED
CONTROL
INTEGRATION
TESTING
DEPLOYMENT
• Use version control for all code (including tests)
• Commit early, commit often
• Use tools
o If it’s hard, people don’t do it
• Train people
• Build often
SOURCE
CONTROL
Requires
Delivers
CONTINUOUS
INTEGRATION:
FUNDAMENTALS
Complete deployment
Incremental deployment
CONTINUOUS
INTEGRATION:
FUNDAMENTALS
Continuous
Integration
Development
Production
Testing
Focus here
QA / Test / Pre-production
Continuous
integration
Build
Test
Trigger
Source
control
Publish
Sync
ALTER
TABLE
foo…
Deployment
script
Release management
Artifact
repository
Development
Continuous delivery for databases
Review,
Backup
& deploy
Production
Deployment
package
deployment package
1
FAI
L
Back to
Development
2
3
Staging matches production
AUTOMATED
DEPLOYMENT
Continuous
Integration
Development
Production
Testing
Database development
and change management
Operations
QA / Test / Pre-production
Continuous
integration
Build
Test
Trigger
Source
control
Publish
Sync
ALTER
TABLE
foo…
Deployment
script
Release management
Artifact
repository
Development
Continuous delivery for databases
Review,
Backup
& deploy
Production
Wait…
AUTOMATED
DEPLOYMENT
Ready to go now?…
…you need a rollback
and recovery strategy
AUTOMATED
DEPLOYMENT
AUTOMATED
DEPLOYMENT
Release pipeline
Test
Development
Production
Continuous Integration
Continuous delivery
Continuous deployment
Approval
gate
Continuous Delivery by Jez Humble and David Farley (Addison Wesley)
The Phoenix Project: A Novel About IT, DevOps, and Helping Your Business
Win by Gene Kim, Kevin Behr and George Spafford (IT Revolution Press)
The Goal: A Process of Ongoing Improvement by Eliyahu M. Goldratt and
Jeff Cox (Gower Publishing Ltd.)
Agile Organization by the agile admin (theagileadmin.com)
www.red-gate.com/delivery
Patterns and practices
Red Gate training academy
www.youtube.com/user/RedGateVideos
Explore Everything PASS Has to Offer
Free SQL Server and BI Web Events
Free 1-day Training Events
Regional Event
This is Community
Business Analytics Training
Local User Groups Around
the World
Session Recordings
PASS Newsletter
Free Online Technical Training