About the Upgrade the Siebel Database Function

When you run the Upgrade the Database function of the Database Configuration Wizard, the wizard prompts you for the upgrade environment (development or production) and the upgrade phase (upgrep or upgphys). The wizard then prompts you for the information required to perform the upgrade.

After collecting and confirming the information, the wizard creates an upgrade configuration file and calls a driver that uses the file to set up the SQL scripts required to upgrade your database.

After you run the Database Configuration Wizard, you run the Upgrade Wizard. The Upgrade Wizard opens a state file containing the steps for the upgrade. These steps execute the SQL scripts created after you ran the Database Configuration Wizard.

To upgrade a development environment, test environment, and production environment, you run the Database Configuration Wizard (and Upgrade Wizard) several times, as listed in the following table.

Upgrade Step	Select This Environment Type	Select This Upgrade Option
Development environment upgrep	Development	upgrep
Development environment upgphys	Development	upgphys
Test environment prepare for production	Production	Prepare for Production
Test environment upgrep and upgphys	Production	upgrep and upgphys
Apply Additive Schema Changes	Production	Apply Additive Schema Changes
Production environment upgrep and upgphys	Production	upgrep and upgphys

The following image shows how the Database Configuration Wizard (and Upgrade Wizard) work together with the Siebel Tools repository merge to upgrade your environments. The steps shown in the following image are as follows:

1. Development Environment Upgrade:

   1. Upgrade Siebel database schema (Upgrep)

   2. Repository merge (Siebel Tools)

   3. Upgrade custom database schema (Upgphys)

2. Merged repository and schema files from development environment are sent to test environment.

3. Test Environment Upgrade:

   1. Prepare for production

   2. Upgrade Siebel database schema (Upgrep and Upgphys)

   3. Upgrade tuning.

4. Transition to Production.