Need for Case sensitive database
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 7.5.2  to 126.96.36.199.11 [IP2013] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 188.8.131.52 
Database: Microsoft SQL Server 2005
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Microsoft Windows 2003 Server
This document was previously published as Siebel SR 38-3293944181.
***Checked for relevance on 01-Oct-2014***
Customer is currently running their development environment in a case-sensitive (CS) database and then move the build to other environments (test, stage, production), all of which have case-insensitive (CI) database. They are on MS SQL Server 2005 database.
Customer wanted to know the queries to the following questions
1. Does Siebel require or recommend doing development in a CS database?
2. If not, is there any performance gain when doing development in a CS database as compared to CI database?
3. Anything else that needs to be considered?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms