My workflow involves a development server, staging server, and production server (fairly common). Content is constantly being maintained on the production server.
If I am running a small code update, it is usually fairly simple since the database is minimally effected. However, on larger long-term updates, there may be significant database changes requiring upgrade database scripts. If the development involves a custom database table, it is easy to build an upgrade script. However, if an update involves changes to content type display, module configuration (from UI), system configuration, fields, or views it can get rather complex tracking down all the changes.
Are there any modules and/or practices that help with this? Thanks.