Click here to monitor SSC

Product Manager at Red Gate Software. My job is to ensure that the Red Gate SQL tools solve as many development and deployment issues as possible.

List of resources for database continuous integration

Published 9 May 2012 12:14 pm

Because there is so little information on database continuous integration out in the wild, I’ve taken it upon myself to aggregate as much as possible and post the links to this blog. Because it’s my area of expertise, this will focus on SQL Server and Red Gate tooling, although I am keen to include any quality articles that discuss the topic in general terms.

Please let me know if you find a resource that I haven’t listed!

General database Continuous Integration

· What is Database Continuous Integration? (David Atkinson)

· Continuous Integration for SQL Server Databases (Troy Hunt)

· Installing NAnt to drive database continuous integration (David Atkinson)

· Continuous Integration Tip #3 – Version your Databases as part of your automated build (Doug Rathbone)

· How the “migrations” approach makes database continuous integration possible (David Atkinson)

· Continuous Integration for the Database (Keith Bloom)

Setting up Continuous Integration with Red Gate tools

· Continuous integration for databases using Red Gate tools – A technical overview (White Paper, Roger Hart and David Atkinson)

· Continuous integration for databases using Red Gate SQL tools (Product pages)

· Database continuous integration step by step (David Atkinson)

· Database Continuous Integration with Red Gate Tools (video, David Atkinson)

· Database schema synchronisation with RedGate (Vincent Brouillet)

· Database continuous integration and deployment with Red Gate tools (David Duffett)

· Automated database releases with TeamCity and Red Gate (Troy Hunt)

· How to build a database from source control (David Atkinson)

· Continuous Integration Automated Database Update Process (Lance Lyons)

Other

· Evolutionary Database Design (Martin Fowler)

· Recipes for Continuous Database Integration: Evolutionary Database Development (book, Pramod J Sadalage)

· Recipes for Continuous Database Integration (book, Pramod Sadalage)

· The Red Gate Guide to SQL Server Team-based Development (book, Phil Factor, Grant Fritchey, Alex Kuznetsov, Mladen Prajdic)

· Using SQL Test Database Unit Testing with TeamCity Continuous Integration (Dave Green)

· Continuous Database Integration (covers MySQL, Perason Education)

2 Responses to “List of resources for database continuous integration”

  1. SqlNightOwl says:

    Thanks David. I’m sold but need to convince management. It would be interesting to have CI on my DB’s before we have CI on the C# app code. :-)

  2. David Atkinson says:

    Maybe turn the tables on management and ask them for reasons to not implement continuous integration! It would definitely be highly unusual for database continuous integration to be put in place before app code, but no reason why not!

Leave a Reply