1. Database Upgrade Guide
  2. About the Siebel Upgrade Wizard and Driver Files

About the Siebel Upgrade Wizard and Driver Files

Environments: Development, Test and Production.

The Upgrade Wizard performs the upgrade. It uses the information collected by the Database 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_811.ucf

  • driver_upgphys_dev_811.ucf

  • driver_upgrep_prod_811.ucf

Here is an excerpt from a driver file that controls a development environment upgrep from Siebel CRM version number 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

[File Execute Entry 2]