When you modify a schema you must complete several tasks to ensure
that your changes are validated, saved, and applied to user databases.
To
modify a schema and put the modifications into effect or to create a new schema:
- Start the Designer.
- Create a test database (or multiple test databases)
in the schema that you want to customize.
- Check out the schema that you want to customize,
or create a new schema.
- Select the scripting language to use the for hook
code.
- Modify the schema, either by using the Designer to
change elements of the schema, or by applying packages.
- Validate the customized schema using the Validate
schema command in the Designer.
- Create a test configuration that specifies the test
database (or multiple databases) for the schema.
- Run the test configuration and test your schema against
the specified databases.
- Save work in progress.
- Check in the customized schema.
- Upgrade the user database with the modified schema.