How to setup the PREREQS for oracle databases

ALter database test

Set READ_COMMITTED_SNAPSHOT = ON

go

Alter database test

Set ALLOW_SNAPSHOT_ISOLATION = ON

go

Select the SQL Server authentication option
when you set the security
properties for the database.

go
>>The schema owner for the above repositories will require DB_OWNER and
>>BULK_INSERT.
>>
>>Run the collate script on the repositories:

>>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 OBIAPP COLLATE ' + @collate)
>>END
>>GO