We have recently gone "live" with ServiceCenter 4.1. We have completely pushed out to Oracle. Now we are working on our first maintenance project. This requires us to add new fields to sevral tables. We have the sqldetect option in our ini file. This allows us to add a field to the dbdict and have it automatically added to Oracle. This seems to work fine, but when we unload the dbdict from our development environment and load it to our test environment, the dbdict does not contain the new fields. My questions are:

1. How are field additions moved to the next environment? Do we have to re-key them?

2. How about changing the name of a field? That does not appear to be picked up by sqldetect. And when we change the SQL mapping, it does not appear to change in Oracle. How should name changes be made, and how are they moved to the next environment?

3. Does anyone have any documentation on adding/changing fields on tables that are pushed to Oracle and on moving to the next environment (e.g. development to test or test to production)? The Data Administration guide is very light in this respect.

Any help would be appreciated.