I am trying to figure out a strategy for upgrading deployed databases
that will be part of a packaged commercial product.

I am assuming that I will have a SQL update script which reads the
target version and contains sections to incrementally upgrade from the
target version through all the intermediate versions to the current
version.

Is there a tool to run these scripts and also have error messages to
alert users (or the upgrade installer) if any step of the upgrade
process failed? Is it usual in these circumstances to roll back all
the changes?

How do people normally handle the DB upgrade issue?

Thanks

Mitch