Siebel Anywhere Administration Guide > Performing Additional Siebel Anywhere Tasks >
Process of Updating the Siebel Database Schema
This topic describes the overall process of using Siebel Anywhere to update the Siebel database schema. Typical schema changes include:
- Adding extension columns to Siebel base tables
NOTE: Due to a technical limitation in the Sybase Adaptive Server Anywhere database, you cannot use Siebel Database Schema upgrade kits to add required, non-null extension columns to existing local database tables. If you make this kind of database change, then you must deploy it by reextracting your Mobile Web Client users.
- Adding extension tables to the Siebel database
- Creating or modifying indexes
To update the Siebel database schema, perform the following tasks:
- Review the information presented in Review What Happens During a Siebel Database Schema Upgrade.
- Make and test the Siebel database schema changes in the development environment, using Siebel Tools. For more information about this step, see Changing the Siebel Database Schema in a Development Environment.
- Move the schema changes to the test environment, using the Siebel Database Configuration Wizard. For more information about this step, see Moving Siebel Database Schema Changes Between Environments.
- Create the necessary upgrade kits in the test environment. For more information about this step, see Creating Upgrade Kits for Siebel Database Schema Changes.
- Prepare the test Mobile Web Clients and Regional Node Servers for the schema changes. For more information about this step, see the following topics:
- Install the schema changes on the test Mobile Web Clients and Regional Node Servers. For more information about this step, see the following topics:
- Move the schema changes to the production environment, using the Siebel Database Configuration Wizard. For more information about this step, see Moving Siebel Database Schema Changes Between Environments.
- Create the necessary upgrade kits in the production environment. For more information about this step, see Creating Upgrade Kits for Siebel Database Schema Changes.
- Prepare the production Mobile Web Clients and Regional Node Servers for the schema changes. For more information about this step, see the following topics:
- Install the schema changes on the production Mobile Web Clients and Regional Node Servers. For more information about this step, see the following topics:
|