Solved

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

Posted on 2010-11-22
6
335 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

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 article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

751 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