Geeks With Blogs
David Atkinson Continuous integration Continuous integration with a database angle
Plug and Play Database Continuous Integration with TeamCity
In a previous blog I describe in twenty one easy steps how to set up continuous integration using a combination of TeamCity and Red Gate tools. Okay, it’s easy only in a relative sense, giving that until recently database continuous integration was almost impossible to set up. One would always suspect that a twenty-one-step process is a long way from the optimal simplicity. Also, having to negotiate the command lines and learning the intricacies of their respective switches and exit codes is tedious ......

Posted On Monday, July 23, 2012 6:06 PM

How to restore your production database without needing additional storage
Production databases can get very large. This in itself is to be expected, but when a copy of the database is needed the database must be restored, requiring additional and costly storage. For example, if you want to give each developer a full copy of your production server, you’ll need n times the storage cost for your n-developer team. The same is true for any test databases that are created during the course of your project lifecycle. If you’ve read my previous blog posts, you’ll be aware that ......

Posted On Monday, May 28, 2012 12:34 PM

The emergence of Atlassian’s Bamboo (and a free SQL Source Control license offer!)
The rise in demand for database continuous integration has forced me to skill-up in various new tools and technologies, particularly build servers. We have been using JetBrain’s TeamCity here at Red Gate for a couple of years now, having replaced the ageing CruiseControl.NET, so it was a natural choice for us to use this for our database CI demos. Most of our early adopter customers have also transitioned away from CruiseControl, the majority to TeamCity and Microsoft’s TeamBuild. However, more recently, ......

Posted On Monday, May 21, 2012 7:43 PM

List of resources for database continuous integration
Because there is so little information on database continuous integration 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? ......

Posted On Wednesday, May 9, 2012 12:10 PM

SQL Server source control from Visual Studio
Developers have long since had to context switch between two IDEs, Visual Studio for application code development and SQL Server Management Studio for database development. While this is accepted, especially given the richness of the database development feature set in SSMS, loading a separate tool can seem a little overkill. This is where SQL Connect comes in. This is an add-in to Visual Studio that provides a connected development experience for the SQL Server developer. Connected database development ......

Posted On Monday, April 30, 2012 12:27 PM

How the “migrations” approach makes database continuous integration possible
Testing a database upgrade script as part of a continuous integration process will only work if there is an easy way to automate the generation of the upgrade scripts. There are two common approaches to managing upgrade scripts. The first is to maintain a set of scripts as-you-go-along. Many SQL developers I’ve encountered will store these in a folder prefixed numerically to ensure they are ordered as they are intended to be run. Occasionally there is an accompanying document or a batch file that ......

Posted On Thursday, April 26, 2012 2:03 PM

Database continuous integration step by step
This post will describe how to set up basic database continuous integration using TeamCity to initiate the build process, SQL Source Control to put your database under source control, and the SQL Compare command line to keep a test database up to date. In my example I will be using Subversion as my source control repository. If you wish to follow my steps verbatim, please make sure you have TortoiseSVN, SQL Compare and SQL Source Control installed. Downloading and Installing TeamCity TeamCity (http://www.jetbrains.com/t... ......

Posted On Tuesday, April 24, 2012 7:18 PM

How to build a database from source control
If your organization has continuous integration in place, it will most likely contain a build step in which your latest application source code gets pulled from source control, compiled, and optionally subjected to a various tests. If you’re a Microsoft shop, chances are that your application works alongside an instance of SQL Server. SQL Source Control allows you to put your schema objects in source control by maintaining a set of per-object creation scripts representing in your existing version ......

Posted On Monday, April 16, 2012 6:18 PM

Installing NAnt to drive database continuous integration
Before we start thinking about database continuous integration, described in an earlier blog post, we need to pick a build tool in which we define the commands for our build process. NAnt is a .NET version of Ant, a tool to drive build processes. Like MSBuild, Microsoft’s equivalent, NAnt build scripts can be driven by continuous automation tools, such as TeamCity, CruiseControl, Bamboo and many others. Yes, it would be possible to drive your scripts with DOS batch files or PowerShell, but NAnt specializes ......

Posted On Monday, April 16, 2012 2:08 PM

What is Database Continuous Integration?
Although not everyone is practicing continuous integration, many have at least heard of the concept. A recent poll on www.simple-talk.com indicates that 40% of respondents are employing the technique. It is widely accepted that the earlier issues are identified in the development process, the lower the cost to the development process. The worst case scenario, of course, is for the bug to be found by the customer following the product release. A number of Agile development best practices have evolved ......

Posted On Thursday, April 12, 2012 6:38 AM

Copyright © David Atkinson | Powered by: GeeksWithBlogs.net