There's no easy answer to your question. Although Opa raises warnings when it detects that the databases your accessing/trying to modify have changed, I guess you'd have to think of a migration process anyway.
What is your best practice so far? (and your expectations :p)
If your having several instances load-balanced, you can easily update your site, one instance after another. No server runs mono-process. What do you think?