How are database updates for applications done commercially?

I am looking for some guidelines on how to save my clients existing data and at the same time update the database with new fields.

Any ideas or thoughts greatly appreciated.