Solved

Need both Case Sensitive and Case Insensitive DBs on SQL Server 2005

Posted on 2010-11-22
6
326 Views
Last Modified: 2012-05-10
Help!!!! Our ERP software requires that we installed SQL Server with Case Sensitive, now I am trying to install a VMWare database and it has to be Case insensitive!  Getting an error that VMware does not support a CS database.  Is there anyway I can accomplish this.  I do not want to buy another SQL server when there is plenty of space on our existing server.
0
Comment
Question by:reboot5
  • 3
  • 2
6 Comments
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34189641
It is dependant upon the temprorary table usage of your database. You can set any database to be either case sentitive or case insensitive. But the instane itself needs to be one or the other.

If both tables use temporary then unfortunatly you will have to put these databases in seperate instances.
0
 
LVL 4

Expert Comment

by:joevi
ID: 34189758
How about using SQL Server Expre$$ for the VMWare instance/database?
0
 

Author Comment

by:reboot5
ID: 34189860
I thought about using SQL Express, but I don't want to run out of room right away..
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:reboot5
ID: 34189878
So if I create a new instance, when this server is a produciton server, if will not intterupt the other databse users?
0
 
LVL 4

Accepted Solution

by:
joevi earned 500 total points
ID: 34189981
Given your requirements I'm not sure you have much of an option. If the production server resources are adequate (Processors, Memory & Disk space) enough to support two instances - you'll be fine.

Note: I'm not a VMWare expert so you may want to check with VMware (or Experts-Exchange Expert) on using Express.
Note2: I feel your pain on Case Sensitive SQL Server configurations. I've yet to see a good reason for it's use in 'typical' database solutions.
0
 

Author Closing Comment

by:reboot5
ID: 34190070
Thanks, it is nce to get others point of views and the response has been quick.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now