Home

Project RoundhousE

"Professional Database Versioning and Change Management"

RoundhousE is an automated database deployment (change management) system that allows you to use your current idioms and gain much more.

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.

We also subscribe to the idea of versioning your database how you want. Version it using the same version as your code base by pointing RH to one of your DLLs. Version it however you want by passing it an xml file and telling it the xpath to the version. Version it based on source control revisions. How sweet is it when you can version the database according to your current source control version?

What is RoundhousE?

RoundhousE is a database migrations engine that uses plain old sql to migrate a database.

Using RoundhousE

Getting Started
Configuration Options
Versioning Your Database
What File Encoding Should My Scripts Be?

Scripts

OneTime Scripts - Your Up folder scripts
AnyTime Scripts - The other folder scripts
Everytime Scripts - The permissions folder & specifically named scripts
Environment Scripts - Specifically named scripts
Token Replacement

Running RoundhousE

RoundhousE Modes
RoundhousE + NHibernate == Rebuild Your Database Inside Visual Studio! - Speed up your Development!

Get RoundhousE

Ways to get RoundhousE

Databases Supported

RoundhousE integrates with the following database types:

• SQLServer 2000 (database type is sql2000)
• SQLServer 2005/2008 including express editions (database type is sqlserver and also the default)
• Oracle 9i/10g/11g (database type is oracle)
• MySQL (database type is mysql) Coming Very Soon

Mailing List

There is a mailing list that encompasses all of the ChuckNorrisFramework - http://groups.google.com/group/chucknorrisframework

More Documentation

RoundhousE documentation definitely needs some love. With each release is a fully functioning sample for SQL Server. It shows off many of the features of RH. You can also see here for any updates: http://projectroundhouse.org

Until this thing is rocking check out the documentation here - https://github.com/chucknorris/roundhouse/tree/master/docs