RCU Preparation

Before running the RCU utility the MS SQL database needs some scripts run on it to make it ready for the next steps.

MS SQL 2008:

alter database vbobi11116 set single_user with rollback immediate;
ALTER DATABASE vbobi11116 SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE vbobi11116 SET ALLOW_SNAPSHOT_ISOLATION ON;
DECLARE @collate sysname
SELECT @collate = convert(sysname, serverproperty('COLLATION'))
IF ( charindex(N'_CI', @collate) > 0 )
BEGIN
select @collate = replace(@collate, N'_CI', N'_CS')
exec ('ALTER database vbobi11116 COLLATE ' + @collate)
END
GO
ALTER DATABASE vbobi11116 SET multi_user with no_wait;

Links:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/hyp/OBIEE11g-E...
http://amit-obiee.blogspot.com/2011/11/installation-of-obiee-11g-r1-1111...