Siebel Database Upgrade Guide > Upgrading the Siebel Database >

Converting Siebel Web Templates with the SWT to OD Conversion Utility

The SWT to OD Conversion Utility converts Siebel Web Templates to an Object Definition Layout. Converted Web templates are stored in the database.

The SWT to OD Conversion Utility runs as part of the upgrade process. Use the procedures in this topic to manually run the SWT to OD Conversion Utility. The SWT to OD Conversion Utility can also be run manually if you need to run template migration for few templates. However, all templates are migrated during the upgrade process.

Running the SWT to OD Conversion Utility

1. Navigate to the following directory:

   Windows: $DbsrvrRoot\common folder

   UNIX: $DbsrvrRoot\common folder

2. Run the following command:

   java -jar $DbsrvrRoot\common\SWTClob.jar /s $SiebelRoot /c "$ODBCDataSource" /t
   $TableOwner /u $TableOwner /p $TablePassword /o $SiebelLogDir /d $DatabasePlatform
   /r $RepositoryName /j $WebTemplatesDir /w $WSUSerName /x $WorkspaceName /b
   $BranchedWS /i $WebTemplateName

   Where:

   • $DbsrvrRoot is the path of the database server installation.
   • $SiebelRoot is the path of the Siebel Server installation.
   • $SiebelLogDir is the path to the log directory.
   • $DatabasePlatform is the database platform, such as Oracle, DB2UDB, MSSQL, and DB2390.
   • $RepositoryName is the Name of the Repository, for example, Siebel Repository.
   • $WebTemplatesDir is the directory for Web Templates, for example, $SiebelRoot/Webtempl.
   • $WebTemplateName is the list of template names for the Incremental Migration. If not passed, all Web Templates are considered for the Incremental Migration.

     The following are the optional parameters that are applicable only for the Workspace Environment.

   • $WSUserName is the Workspace owner user, for example, SADMIN.
   • $WorkspaceName is the Workspace Name to be created, for example, dev_xxxx_xxx.
   • $BranchedWS is the Workspace Branch under which the $WorkspaceName needs to be created, for example, MAIN.
3. Review the SWTClob log and verify that SWTClob ran without errors.

   Windows: $SiebelLogDir\SWTClob.log

   UNIX: $SiebelLogDir/SWTClob.log

   For more information about troubleshooting and verifying the results of the Web template migration process, see Using Siebel Tools.