Bookshelf Home | Contents | Index | PDF |
Upgrade Guide > How the Siebel Database Upgrade Works > About the Siebel Upgrade Wizard and Driver FilesUpgrades: All Siebel upgrades. 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:
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: File Name = rename_existing_repositories.sql Title = Verify Repository Name File Name = $SiebelRoot\bin\odbcsql 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 File Name = $SiebelRoot\bin\odbcsql 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 How To Locate Upgrade Driver Files and SQL ScriptsDriver files are stored in the following location: Windows: UNIX:
For example, if you are upgrading from Siebel 7.7, the driver file for the development environment upgrep is as follows: 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 |
Upgrade Guide | Copyright © 2006, Oracle. All rights reserved. | |