Rails style database migration for asp.net?

Question

I am in love with the rails style of updating the db circuit. I can define a transition as a class with a fairly simple but powerful syntax. I can run updates with a single command, and all my models are updated. They aim to control the source and can be easily read, modified and canceled.

My current way to do this for my asp.net mvc project is to open the server explorer, manually change the database fields, and then restore all my linq-to-sql classes. This method is cumbersome, error prone and does not have almost all of the advantages listed above. I am sure there must be a better way.

Can anyone enlighten me?

Answer 1

Rob Conery Subsonic has a bit of a migration to .NET:

http://blog.wekeroad.com/2007/10/03/subsonic-migrate-me/

There are many other toolkits that offer similar approaches:

• Migrator.net
• RikMigrations and InfoQ article this

I am sure there are more.

Answer 2

An old question, but still valid, so here is another answer that may be useful to someone.

This question / answer here on SO contains a list of candidates and be sure to check out the Fluent Migrator .