Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-11-22
6
Medium Priority
?
343 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

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 2000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

688 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