Is there some standard way to test migrations?
It seems to me that an additional safeguard for migrations would be to
test and see if applying the migrations to the test database allows one
to reconstruct the structure of the development database.
If you can’t, then there is an error in your migrations, most likely
because someone hand-modified the database without generating a
migration for it.
The biggest problem with writing unit tests for this is that (AFAIK)
there is no simple way to apply migrations to the test database instead
of the development one.
Is there a simple switch or something in rake that will make it use the