> OK, but if your customer lost all the data in the database
> (including these
> records), how would you ever know what to upgrade from again? I guess I'm
> kinda answering my own question here - put this information somewhere
> outside of the database, but be sure to include a copy of it somewhere. I
> guess this could be stored redundantly with the application (ie. 'Last DB
> Version used' or something like that).

the application continues to carry all previous upgrade scripts with it. If
you placed app verion 2.8.00 against a brand new (old) empty database
version 1.0, then the app would immediately bring the db up to version 2.8
via however many steps, each one relying on the previous version upgrade.

Alan