Converting Obsolete Column Types on Oracle and Microsoft SQL Server Database Platforms

Environments: Development, Test, Production

Databases: Oracle, MSSQL

After performing an upgrade, it is possible that there will be obsolete column types defined in the Siebel Repository, physical database, or both, these include:

Database Platform	Obsolete Type	Modern Type
Oracle	LONG	CLOB
Microsoft SQL Server	NTEXT / TEXT	NVARCHAR(max) / VARCHAR(max)

The utility LongDataTypeMigration, found in the ...\siebsrvr\bin folder on Windows servers, can be used to migrate existing Repository and physical column definitions to modern data types without data loss.

The parameters are:

Argument	Description	Examples
/s	The path to the Siebel Server Root folder	C:\Siebel
/u	Tableowner username	SIEBEL
/p	Tableowner password	********
/c	ODBC Source	Siebel_DSN
/t	Tableowner	SIEBEL, dbo
/l	Log folder for output	C:\Siebel\siebsrvr\logs
/a	Apply Alter SQL	Determines whether or not the generated ALTER TABLE statements will be executed or not. This allows them to be run asynchronously by a DBA. Y—Make the physical changes N—Only generate a SQL file
/r	Repository name	Siebel Repository

The following are examples for each platform:

Oracle:

java -jar LongDataTypeMigration.jar /s
        C:\Siebel\\siebsrvr /u SIEBEL /p ******** /t SIEBEL /c siebel_DSN /d ORACLE /l
        C:\Siebel\siebsrvr\log /a N /r "Siebel Repository"

MSSQL:

java -jar LongDataTypeMigration.jar /s
        C:\Siebel\siebsrvr /u SIEBEL /p ******** /t dbo /c siebel_DSN /d MSSQL /l
        C:\Siebel\siebsrvr\log /a Y /r "Siebel Repository"