>> In general, I think that database migrations are fundamentally flawed. The database schema and the application should have a schema version that they expect, and rules for translating between versions.

I have the same feeling, that could be a very desirable native feature for DB Engine, but no vendor seems to be interested in addressing that.