Siebel Database Upgrade Guide > How the Siebel Database Upgrade Works >
About the Siebel Upgrade Wizard and Driver Files
Upgrades from: All 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_77.ucf
- driver_upgphys_dev_77.ucf
- driver_upgrep_prod_77.ucf
- driver_upgphys_prod_77.ucf.
Here is an excerpt from a driver file that controls a development environment upgrep from Siebel 7.7 on Oracle. 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 = the database type, for example ORACLE
VERSION = the version from which you are upgrading, for example V7.7
For example, if you are upgrading from Siebel 7.7, the driver file for the development environment upgrep is as follows: driver_upgrep_dev_77.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 Server Configuration Utilities
ForExample of a Siebel Development Upgrade Flow
About the Siebel Repository Merge
|