it would be nice to see a module developed for drupal, that would use CRON and CVS to keep a live website updated to the latest changes in the drupal CVS system (while preserving conf/settings files of course). something like this would also need some way to *know* to update the sql when needed (maybe have a script that would compare installed version of drupal against latest version/date in CVS, and run any sql changes that have been made between those dates? i doubt this is possible without alot of trouble tho)
alternatively for the sql update part, if a script were to at least detect the presence of sql changes, and create a notice in the Administration that the sql should be updated, that would be nice.