Geeks With Blogs

News
Rob Reynolds

Subscribe to Fervent Coder RSS
Subscribe to Fervent Coder by Email

About Me

I manage several open source projects. Need...
   ...package management for Windows?
   ...automated builds?
   ...database change management (migrations)?
   ...your application to check email?
   ...a monitoring utility?

I also write for



Like what you are reading? Want to buy me a cup of coffee?
PayPal - The safer, easier way to pay online!

Fervent Coder Coding Towards Utopia...by Rob Reynolds

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

Posted on Wednesday, November 11, 2009 4:51 PM | Back to top


Comments on this post: Enter The Dragon: RoundhousE DB Migrations

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
Do a screenie!
Left by Dave Laribee on Nov 11, 2009 5:14 PM

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
@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.
Left by Robz on Nov 12, 2009 4:42 AM

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
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) :)
Left by Aaron Lerch on Nov 12, 2009 9:33 AM

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
@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.
Left by Robz on Nov 12, 2009 4:08 PM

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
So - think Tarantino !!!
Left by MIK on Feb 06, 2010 11:44 AM

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
Да, очень интересно, супер прикол.
Left by интерент магазин футболок on Feb 08, 2010 11:22 AM

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
нормально написал , респект
Left by камасутра on Mar 06, 2010 8:39 AM

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
респект , все по полкам разложил
Left by камасутра скачать on Mar 06, 2010 8:42 AM

# re: Enter The Dragon: RoundhousE DB Migrations
Requesting Gravatar...
Спасибо автору , все доходчиво описанно!
Left by мото форум on May 03, 2010 2:49 AM

Comments have been closed on this topic.
Copyright © Robz / Fervent Coder | Powered by: GeeksWithBlogs.net | Join free