R – nhibernate + migrations workflow

databasemigrationnhibernateversion control

I'm looking to refine my workflow around NHibernate and a relatively frequently changing schema, and how best to deal with this – I would like the same solution to apply to production systems, so I think I need a migration engine rather than just Schema Update.

What I want to know is how i can refine the workflow as far as possible so that I'm doing as little work as possible to get my database in sync with my domain model. The tarantino approach of scripts looks nice, but there doesn't seem to be a way to generate the update script from my nHibernate mappings, so i'm down to hand crafting a script or using a redgate sql compare like tool. Is there anything I'm missing that would make life easier around the script generation stage?

Thanks,
Chris

Best Answer

I haven't used any of these migration tools for .net myself, but when trying out Ruby on Rails on my spare time some years ago, I saw the benefits of migrations compared to the t-sql scripts we used at my job at the time.