Applying Siebel Additive Schema Changes
Use the following procedure to apply Siebel additive schema changes.
To apply additive schema changes
Navigate to the directory where
schema.additive.sql
is located.Review the script and verify that it does not make unacceptable changes to the schema.
Production environment only. Compare the script generated in the production environment with the one generated in the test environment. If the scripts are not identical, then determine why. If you cannot determine that the differences are benign, then do not apply additive schema changes in the production environment.
Using any SQL editor, run the script against the Siebel database.
You can run
schema.additive.sql
multiple times. For example, you can run the script, revise it, and run it again.