agile database development l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Agile Database Development PowerPoint Presentation
Download Presentation
Agile Database Development

Loading in 2 Seconds...

play fullscreen
1 / 17

Agile Database Development - PowerPoint PPT Presentation


  • 260 Views
  • Uploaded on

Agile Database Development. Nathan Voxland. You Plan For Your Code To Change. Why Do You Act Like Your Database Doesn’t?. Knee Jerk Reactions:. Plan your Database Up Front Database can only be touched by the anointed DBA ORM/Mapping configuration work- arounds

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Agile Database Development' - issac


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
you plan for your code to change
You Plan For Your Code To Change

Why Do You Act Like Your Database Doesn’t?

knee jerk reactions
Knee Jerk Reactions:
  • Plan your Database Up Front
  • Database can only be touched by the anointed DBA
  • ORM/Mapping configuration work-arounds
  • All database access through views and stored procs
treat your database like your code
Treat Your Database Like Your Code
  • Build the simplest thing that can possibly work
  • Refactor
  • Test changes
  • Version Control
  • Branches
  • Maintainable
redgate sql compare
RedgateSql Compare

Compares and Synchronizes SQL Schemas

activerecord migration
ActiveRecord::Migration

Tracks the current version of the database in the database

liquibase
LiquiBase

The Perfect Solution 

what kind of changes
What Kind of Changes?
  • All Changes
  • New Tables
  • Modifications to Tables
  • Reference Data
lots of execution tricks
Lots of Execution Tricks
  • Update
  • UpdateSQL
  • UpdateCount
  • Rollback
  • FutureRollbackSQL
  • GenerateChangeLog
  • Tag
  • DBDoc
  • Diff
lots of changelog flexibility
Lots of Changelog Flexibility
  • Database Independence
  • Modular Changelogs
  • Contexts
  • Parameters
  • Preconditions
  • Complex Refactorings
  • Custom Changes
questions
Questions?

http://liquibase.org