Enter The Dragon: RoundhousE DB Migrations

RoundhousE_LogoOne of the coolest projects I have been working on is how to solve issues with database versioning and migration. A project dubbed RoundhousE.

RoundhousE is an open source automated database deployment (change management) system that allows you to use your current idioms and gain much more. Currently it only supports Microsoft SQL Server, but there are future plans for other databases.

It seeks to solve both maintenance concerns and ease of deployment. We follow some of the same idioms as other database management systems (SQL scripts), but we are different in that we think about future maintenance concerns. We want to always apply certain scripts (anything stateless like functions, views, stored procedures, and permissions), so we don’t have to throw everything into our change scripts. This seeks to solves future source control concerns. How sweet is it when you can version the database according to your current source control version?

RoundhousE (RH) is a very lean implementation for database migration that uses SQL Scripts to apply changes to a database. It is extremely configurable in that you can override the conventions for everything, including the schema, version table, and scripts run table for RH. RoundhousE is implemented as an MSBuild/NAnt Task, a console application (the console is still in development), and in the future possibly a GUI as well. There is an extensive roadmap on the product. Over the next few weeks I will be talking about how to set up and use this product and future enhancements.

 

Until then, enjoy this image of Chuck showing off his intimate knowledge of open source!

image 

Next in the spin: RoundhousE DB Migration: Action Shots

kick it on DotNetKicks.com Shout it

Print | posted @ Wednesday, November 11, 2009 4:51 PM

Comments on this entry:

Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
by Dave Laribee at 11/11/2009 5:14 PM

Do a screenie!
Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
by Robz at 11/12/2009 4:42 AM

@Laribee: What's a screenie? There is an app out there somewhere called screenie. Is that what you are talking about?

I would have had a screenshot of it in action, but I don't have SQL Server re-installed on my lappy yet.
Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
by Aaron Lerch at 11/12/2009 9:33 AM

He meant a screencast of how it works, how to use it, etc.

I'd like to see some info on what this offers that's different/better than tarantino or migrator.net (for example) :)
Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
by Robz at 11/12/2009 4:08 PM

@Aaron: I had an idea that's what he meant. So - think Tarantino, but with much more leverage. Download the source, run build.bat - then go into code_drop\deployment and run the LOCAL.DBDeploy.bat.
Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
by MIK at 2/6/2010 11:44 AM

So - think Tarantino !!!
Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
Да, очень интересно, супер прикол.
Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
by камасутра at 3/6/2010 8:39 AM

нормально написал , респект
Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
респект , все по полкам разложил
Gravatar # re: Enter The Dragon: RoundhousE DB Migrations
by мото форум at 5/3/2010 2:49 AM

Спасибо автору , все доходчиво описанно!
Comments have been closed on this topic.