|
Size: 598
Comment:
|
Size: 1673
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| = Maintaining SQL-based Clients = | === Maintaining SQL-based Clients (updateccdb utility) === '''updateccdb''' utility works for current company only. You need to change company using '''conset -c''' to update different company. * '''updateccdb -a''' should be added to crontab list. It will check all tables for new/changed fields to avoid invalid read/write request and analyze tables (-a option) to improve performance. |
| Line 5: | Line 8: |
| * 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 |
* If any new fields have been added to any record, '''updateccdb''' should be run. To ensure that the programs refer to the correct fields it is good idea to run '''updateccdb''' every time when new programm getting copied to customer site. * Programmers should be very wary of '''renaming''' fields, especially if the data in those fields are to stay in use. In this case utility would need to be run to ensure the field renaming happens correctly. {{{ updateccdb -r -o oldName -n newName -f fileName|All #-f All will rename columns for ALL datatypes. }}} * If the field is just being renamed as it is being taken out of use or used for something else (if data should not be transfered from old field to new one), '''updateccdb''' will leave old one in the database and create column for new one (if the new one is not one of those '''FILL''' field). To reclaim disk space you need to run '''updateccdb''' with '''-d''' option (it will prompt for confirmation for each field being removed). * '''FOR PROGRAMMERS:''' If for some reason we will need to change internal database type we should run: {{{ updateccdb -c -o oldtype }}} |
Maintaining SQL-based Clients (updateccdb utility)
updateccdb utility works for current company only. You need to change company using conset -c to update different company.
updateccdb -a should be added to crontab list. It will check all tables for new/changed fields to avoid invalid read/write request and analyze tables (-a option) to improve performance.
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. To ensure that the programs refer to the correct fields it is good idea to run updateccdb every time when new programm getting copied to customer site.
Programmers should be very wary of renaming fields, especially if the data in those fields are to stay in use. In this case utility would need to be run to ensure the field renaming happens correctly.
updateccdb -r -o oldName -n newName -f fileName|All #-f All will rename columns for ALL datatypes.
If the field is just being renamed as it is being taken out of use or used for something else (if data should not be transfered from old field to new one), updateccdb will leave old one in the database and create column for new one (if the new one is not one of those FILL field). To reclaim disk space you need to run updateccdb with -d option (it will prompt for confirmation for each field being removed).
FOR PROGRAMMERS: If for some reason we will need to change internal database type we should run:
updateccdb -c -o oldtype