Siebel Database Upgrade Guide > How the Siebel Database Upgrade Works >

About the Siebel Upgrade Wizard and Driver Files

Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

The Upgrade Wizard performs the upgrade. It uses the information collected by the Database Server Configuration Utilities to execute commands and SQL scripts. These commands and SQL scripts are contained in driver files. Driver files are in ASCII text format and are organized into steps. The Upgrade Wizard reads the steps in the driver files and performs the commands contained in each step.

In a driver file, steps are separated by a blank line, and each step begins with a File Execute Entry number. The key part of each step is the command or script to be executed. When an SQL script is specified, you can review the script and see what changes it will make to the Siebel Database before running the Upgrade Wizard.

Driver files are provided for each of the major upgrade operations. Examples of driver files are as follows:

• driver_upgrep_dev_80.ucf
• driver_upgphys_dev_80.ucf
• driver_upgrep_prod_80.ucf

Here is an excerpt from a driver file that controls a development environment upgrep from Siebel CRM 8.x on Oracle Database. The excerpt contains three steps:

[Sql File Entry 0]

Type = DbSql

File Name = rename_existing_repositories.sql

Use Table Owner = 1

Use System Admin = 0

IgnoreAllDDLErrors = 0

IgnoreAllDMLErrors = 0

Argument 0 = $SiebelVersion

Title = Verify Repository Name

Title Message Num = 0

Estimated Disk Space = 0

Backup Db = 0

Parallelizable Item = 0

Prompt User For Status = 0

[File Execute Entry 1]

Type = FileExecute

File Name = $SiebelRoot\bin\odbcsql

Check Return Code = 1

Return Code Compliance = 0

16 Bit App = 0

Command Line = /s "$ODBCDataSource" /u $TableOwner /p $TablePassword /separator / /a /c rem /l $SiebelLogDir/dropif-db.log $DbsrvrRoot/$DatabasePlatform/dropif-db.sql /v

Number of 10 Second Wait Loops = 2000

Return Code = 0

Title = Drop interface tables

Title Message Num = 0

Estimated Disk Space = 0

Backup Db = 0

Parallelizable Item = 0

Prompt User For Status = 0

[File Execute Entry 2]

Type = FileExecute

File Name = $SiebelRoot\bin\odbcsql

Check Return Code = 1

Return Code Compliance = 0

16 Bit App = 0

Command Line = /s "$ODBCDataSource" /u $TableOwner /p $TablePassword /separator / /a /c rem /l $SiebelLogDir/trigdrop-db.log $DbsrvrRoot/$DatabasePlatform/trigdrop-db.sql /v

Number of 10 Second Wait Loops = 2000

Return Code = 0

Title = Drop triggers

Title Message Num = 0

Estimated Disk Space = 0

Backup Db = 0

Parallelizable Item = 0

Prompt User For Status = 0

How To Locate Upgrade Driver Files and SQL Scripts

Driver files are stored in the following location:

Windows: DBSRVR_ROOT\PLATFORM\UPGRADE\VERSION

UNIX: DBSRVR_ROOT/bin/PLATFORM/UPGRADE/VERSION

where:

• PLATFORM indicates the database type, for example ORACLE
• VERSION indicates the version from which you are upgrading, for example V8.0

For example, if you are upgrading from Siebel 7.7, the driver file for the development environment upgrep is as follows:

driver_upgrep_dev_80.ucf

Most of the SQL scripts generated or populated for the upgrade are stored in the same directory as the driver file. The remaining SQL scripts are stored in the \PLATFORM directory.

Related Topics

About the Siebel Database Upgrade Process

About the Siebel Database Configuration Utilities

Example of a Siebel Development Upgrade Flow

About the Siebel Repository Merge