Transactional Migrations

Ensure schema changes are wrapped in atomic transactions to guarantee consistency on failure.