Stored procedures. Blow them away and recreate them all from source after you run your schema and data migration scripts. Then you'll know at build time wheth

Stored procedures. Blow them away and recreate them all from source after you run your schema and data migration scripts. Then you'll know at build time whether your queries still match the schema. It helps to also not be afraid of the star when writing queries. That can keep you safe from missing new columns. You just need to take a bit of care and think about what you're doing.