Roy mentions RikMigrations. I too am quite ignorant about Ruby, though I am certainly aware of how popular it has become.

Something to keep an eye on which might be useful in the future.

Currently we use Red Gate’s SQL Compare to do a diff between our test and production databases. SQL Compare then generates the necessary T-SQL to modify the production schema to synchronise it to the same as test.

This works very well for us, so I’m interested as to what benefits a tool like RikMigrations would bring.