Maintaining SQL-based Clients
Below are a few things you should consider before installing or updating any new sql programs:
If any new fields have been added to any record, updateccdb should be run. This is to ensure that the programs refer to the correct fields.
Programmers should be very wary of renaming fields, espicially if the fields are to stay in use. If the field is just being renamed as it is being taken out of use, then it should be fine. Otherwise, a utility would need to be run to ensure the field renaming happens correctly