devops drive-in: automate database deployments in your continuous delivery pipeline with serena and...

Automate Database Deployments in Your Continuous Delivery Pipeline with Serena and Datical

SERENA SOFTWARE INC.

September 18, 2014

Today’s Presenters

Julian FishDirector of Products

Serena

Robert ReevesDatical CTO

SERENA SOFTWARE INC.

3

Introduction to Serena

• Founded 1980

• Headquartered in San Mateo, CA • >$200M revenue

• 200+ R&D Engineers

• HGGC Portfolio Company

• Follow the sun Support

• Serena Deployment Automation• Increase Deployment Velocity

• Quality, Predictability, Repeatability

• Visual Process Definition

• Helping Global 2000 enterprises build and release better software

Introduction to Datical

• Founded 2012

• Headquarters in Austin, Texas

• Datical DB – Application Schema Management• Manage

• Control

• Accelerate

• Datical DB and Serena Deployment Automation:• Plugin: www.datical.com/serena• Community Edition

SERENA SOFTWARE INC.

5

Eat, Sleep, Deploy, Repeat…

A Continuous Delivery Process is a deployment process that is simple, repeatable and predictable.

The same process should be used regardless of your development and testing tools.

The lighter the process, the easier to understand, use and gain ROI

Deployment Software should augment your process; not define it…

SERENA SOFTWARE INC.

6

Serena DA Overview

7

Components of a Continuous Delivery tool-chain

SERENA SOFTWARE INC.

DEV

CI

UT

D

R

Change

• Dev – Development

• CI – Continuous Integration

• UT – Unit Test (A)

• D – Deploy

• AT – Auto Test

• R – Release (Deploy)

AT

SERENA SOFTWARE INC.

8

Deployment Tool chain

SERENA SOFTWARE INC.

9

We know how to deploy applications faster..

Serena Deployment Automation:• Reduces Cycle Time

• Produces Repeatable Deployments

• Ensures Traceability and Audit Compliance

• Automates complex deployment tasks

• Supports CI / CD Deployment Pipelines

• Seamlessly Integrates with third party Applications

• Graphically models your deployment processes

SERENA SOFTWARE INC.

10

How do we manage Database Complexity..?

• Application of changes

• Rollback of changes

• Tracking and monitoring of Schema Changes

• Application of DDL / DML

Manual Database Deployments

Vision

Reality

Solution

Continuous Delivery rapidly produces software products and services

Manual processes/Database Changes stop you from reaching your vision

Serena Deployment Automation and Datical DB

The Problem with Manual Deployments

• They’re slow

• They rely on “tribal knowledge” to be successful

• You don’t know who deployed what, where, or when

• There’s no consistency across environments

YOU FAIL IN PRODUCTION!

Deployment Weekends

I don’t really like my kids

anyway…

You Can’t Do That!!!

• “Rail travel at high speed is not possible because passengers, unable to breathe, would die of asphyxia.” - Dr Dionysys Larder (1793-1859)

• “There’s no chance that the iPhone is going to get any significant market share. No chance.” - Steve Ballmer, CEO of Microsoft, 2007

• “Heavier-than-air flying machines are impossible.” - Lord Kelvin, 1895

• “A rocket will never be able to leave the Earth’s atmosphere.” - New York Times, 1936

• "I think there is a world market for maybe five computers.” - Thomas Watson, chairman of IBM, 1943

Database Change Management Challenges

Test

Development

Build

Code

Database Change Management Challenges

Test

Release

Test

Development

Build

Code

Database Change Management Challenges

ProductionTest

Release

Test

Development

Build

Code

Database Change Management Challenges

Production

SQL Script 1

SQL Script 3

SQL Script 2

Test

Release

Test

Development

Build

Code

Database Change Management Challenges

ProductionTest

Release

Test

Development

Build

Code

SQL Script 1

SQL Script 3

SQL Script 2

Database Change Management Challenges

ProductionTest

Release

Test

Development

Build

Code

SQL Script 1

SQL Script 3

SQL Script 2

Database Change Management Challenges

ProductionTest

Release

Test

Development

Build

Code

SQL Script 1

SQL Script 3

SQL Script 2

Database Change Management Challenges

ProductionTest

Release

Test

Development

Build

Code

SQL Script 1

SQL Script 3

SQL Script 2

Database Change Management Challenges

Production

Manual Change Manual Change

Test

Release

Test

Development

Build

Code

SQL Script 1

SQL Script 3

SQL Script 2

Database Change Management w/Datical DB

Test

Development

Build

Test Production

ReleaseCodeCod

eDaticalDB

Database Change Management w/Datical DB

Test

Development

Build

Test Production

ReleaseCodeCod

eDaticalDB

ModelEasily create and model database changes across your software release stages.

Database Change Management w/Datical DB

Test

Development

Build

Test Production

ReleaseCodeCod

eDaticalDB

ModelEasily create and model database changes across your software release stages.

ForecastProactively scrutinize the impact of database changes in production – or any other environment – before you deploy.

Database Change Management w/Datical DB

Test

Development

Build

Test Production

ReleaseCodeCod

eDaticalDB

ModelEasily create and model database changes across your software release stages.

ForecastProactively scrutinize the impact of database changes in production – or any other environment – before you deploy.

DeployDeploys database schema changes to multiple databases and mixed environments simultaneously.

Database Change Management w/Datical DB

Test

Development

Build

Test Production

ReleaseCodeCod

eDaticalDB

ModelEasily create and model database changes across your software release stages.

ForecastProactively scrutinize the impact of database changes in production – or any other environment – before you deploy.

DeployDeploys database schema changes to multiple databases and mixed environments simultaneously.

ManageConfidently know the current state of the database and how it got there across the application release lifecycle.

Datical Product Overview

Deploy Plan

DEV

QA

PROD

Datical Product Overview

Deploy Plan

DEV

QA

PROD

Datical DB Engine

Datical Product Overview

Deploy Plan

DEV

QA

PROD

ChangeSet 1

ChangeSet 2

ChangeSet 3

ChangeLog

Datical DB Engine

Datical Product Overview

Baseline

Captures the current state of the database

Compare

Provides schema differences between environments

Forecast

Impacts analysis of proposed changes

Deploy

Executes changes to the database

Rollback

Undo select database changes

Audit

Provides visibility into database changes

Deploy Plan

DEV

QA

PROD

ChangeSet 1

ChangeSet 2

ChangeSet 3

ChangeLog

Datical DB Engine

Datical Product Overview

Baseline

Captures the current state of the database

Compare

Provides schema differences between environments

Forecast

Impacts analysis of proposed changes

Deploy

Executes changes to the database

Rollback

Undo select database changes

Audit

Provides visibility into database changes

C:\datialdb.exe

user@host:~$./daticaldb

Datical DB UI Datical DB CLI Integrations

Deploy Plan

DEV

QA

PROD

ChangeSet 1

ChangeSet 2

ChangeSet 3

ChangeLog

Datical DB Engine

Datical DB & Serena Release Automation

datical.com/serena

SERENA SOFTWARE INC.

34

Database Deployment: Process Definition

SERENA SOFTWARE INC.

35

Running a Deployment Process

SERENA SOFTWARE INC.

36

Visualize Database Deployments

SERENA SOFTWARE INC.

37

Managed and Controlled Database Deployments

Questions?

SERENA SOFTWARE INC.38

Weekly Deployment Automation Demo

Free Deployment Automation

Please use the Q&A panel to submit your questions.

Friday 1 pm ET/ 10 am PT

Upcoming DevOps Drive-InOctober 30th!

We’ll send you an invite for the next DevOps Drive-In!

Want to See More?

SERENA SOFTWARE, INC.39

serena.com/sda

More Information

• Serena Deployment Automation Community Edition• serena.com/sda

• DaticalDB4SerenaDA• datical.com/serena

• Bring Agile Development to the Database• datical.com/agile

• Contact info@datical.com

(949) DATICAL (328-4225)

@datical

fb.com/datical