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

Environments: Development, Test, Production

Databases: Oracle, MSSQL

After performing an upgrade, it's 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.

For a list of parameters you can use with the LongDataTypeMigration utility, see: About LongDataTypeMigration.