> I've been doing it this way for years. I always apply the schema to a db
> copy (and test it there) before applying to the production version.
> I've never had to restore a backup under these instances.
> What case are you thinking of with regard to schema error?
> Alan
>

I guess if the testing was incomplete (you can never get 100% code
coverage) ie errors appearing in complex stored procedures/triggers
and/or interaction with the code in the client application.

It would be very useful to be able to safely & simply roll back the
schema and client application version while fixing the bug/s.

Mitch