iltam database version control

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

CONTROL.DEPLOY.PROTECT.COMPLY

Database Version Control

ILTAM – January 2013

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

About dbMaestrodbMaestro provides the first and only DCM (Database Change Management) solution allowing IT organizations to improve the service provided to the business by adopting best practices methodologies to the Database Tier. Leveraging unique technology that enforces Change Policy and Deployment automation, dbMaestro enables the Development & IT teams to mitigate deployment and development risks and increase team collaboration, thus keep availability of the main services, while increase the updates rate.

Introduction

Uri Margalit: Director of Products at dbMaestro +20 years experience in enterprise management R&D Director at Precise / VERITAS / Symantec

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

dbMaestro: Orchestrate Your DatabaseStreamline Database Development Process

Reduce DatabaseDevelopment Costs

Instill Change Policy Enforcement

Mitigate Deployment Risks

Automate Deployment Process

Reduce Deployment cost by 95%

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

4

DCM DCM – Database Change Management Part of ALM (Application Lifecycle Management)

solutions

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

5

Risks of not Having a DCM Lack of Visibility into the Lifecycle of Releases Problems with Concurrent Database Development Inconsistent Database Environments Little or No Capability for Automated Tasks Meeting Release Schedules with Desired Quality Less Agility in Responding to Scope Changes

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

Version Control Concepts Structure of repository & gained functionality

6

File based Separation of Working

environment and repository File Locking Check out / in Baseline Tag / Label Head / Latest Rollback Compare / Merge Deploy / Build

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

SCM Concepts in the database world Traditional SCM concept doesn’t fit the Database

world… A database is not a collection of files DDL (Data Definition Language) DML (Data Manipulation Language) DDL extraction No debug environment Content ? Database duplication – constant synchronization

7

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

SCM Concepts in the database world Moving changes… Development to QA, integration and production

Code – simple file copy & registration DB objects cant just be “moved” – content… What do we do with db content changes ?

So the whole thing was neglected for years...

Manual process where created to deal with real life situations

8

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

9

Without DCM - Two Isolated Processes

Check-Out Script

Modify Script

Get updated Script from DB

Check-In Script

Compile Scriptin DB

Debug Scriptin DB

Version Control Process Development Process

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

10

DATABASE ?!Any Change Tested Over Night

ALM without DCM

SCM Native CodeBusiness

Req. Integration

Conflict code Resolver

Automated Deployment

Continuous Integration

File Based Version Control: Java, .NET, C#, C++

Change Management Systems

Correlate Change with Activity

Merge Code

Agile

Quick Iterations

Reduce Overhead

Increase Team Satisfaction

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

11

Development & Version Control Process

With DCM - One Enforced Process

Check-Out Object

Modify Object in DB

Run Applications’

Tests

Check-In Object

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

12

ALM with DCM

SCM Native CodeDCM

Database Code

Business Req.

Integration

Conflict code Resolver

Automated Deployment

Continuous Integration

Any Change Tested Over Night

File Based Version Control: Java, .NET, C#, C++

Change Management Systems

Correlate Change with Activity

Merge Code

MergeDatabaseChanges

Agile

Quick Iterations

Reduce Overhead

Increase Team Satisfaction

Database Version Control

Change Policy

Automatic Deployment Script

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

13

Benefits - Development Database Changes Repository Following SCM methods (Check-Out/Check-In) All Changes are documented Control Who can do What, Where, When & Why

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

14

Benefits - Deployment Integrated Deployment Engine Business Level Audit Roles & Responsibilities Enforcement

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

15

Demo

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

16

Change Policy Enforcement

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

17

Impact Analysis

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

18

Conflict Resolver - Code

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

19

Conflict Resolver - Content

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

20

Deployment Script

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

21

Baseline in Deployments

Source vs. Target

Action

= No Action

≠ ?

Source vs. Baseline

Target vs. Baseline

Action

= = No Action

≠ = Override

= ≠ Ignore

≠ ≠ Merge

You do not have all the information

With Baseline the unknown is now known

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

22

SummaryBuild a good Safety NetReduce Deployment issues Control Your Database DevelopmentKnow Who did What, Where, When and WhyAutomate Deployments

www.dbmaestro.com CONTROL.DEPLOY.PROTECT.COMPLY

23

Thank You

Thank you for your time

Uri Margaliturim@dbmaestro.com