John, Just be very, very careful here. Obviously, seeking the opinion of professionals is the way to go (having a conversation with your internal DBAs) but DO NOT underestimate the effect that case sensitivity will have on your user community, especially with regards to searches. Your DBAs may tell you that you can turn case sensitivity OFF in Oracle 10g, but the AR System cannot access the database efficiently with case sensitivity turned off (I believe it will always do a full table scan when searching with case sensitivity turned off). Therefore, you will be relegated to either entering everything in your database in ALL CAPS, all lowercase or telling your users that when they search in the database they MUST KNOW how the data was entered to search against it.
Just my .02 cent warning. We had a client that wanted to go with 10g for many of the same reasons you did, then, after installation, decided that the case sensitivity issue was much more important the previously thought. Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Bilinski, John Sent: Tuesday, January 06, 2009 2:30 PM To: [email protected] Subject: Re: Oracle 10g vs. SQL 2005 for supporting ITSM 7.1 Thanks Joe, >From my conversation with some internal DBA's and I think the winner is Oracle >10g due to the superior Replication features. Thank you so much. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Tuesday, January 06, 2009 10:04 AM To: [email protected] Subject: Re: Oracle 10g vs. SQL 2005 for supporting ITSM 7.1 ** John, While neither of the databases are 'bad' each has its own advantages or disadvantages. The biggest advantage of using MS-SQL is that if you do not have a dedicated DBA, most administration tasks on MS-SQL are doable by a non DBA with some knowledge of how it all works. Also by default the database is not case sensitive which makes searching a little more easier than it is on Oracle that has to be set up as case insensitive. Oracle on the other hand has powerful DBA tools that usually an expert level DBA can take advantage of. The administration tools available with Oracle in my opinion are way more powerful than those available with MS-SQL. So it is definitely the choice of a DB for a bigger shop that would expect its database to grow up to be ginormous over a few months/years. At the end of the day look at your available resources and what your company is willing to invest to take care of that database. If you do not have Oracle DBA's is your organization willing to spend that extra 80 to 120K a year for one? You definitely do not want Oracle if you do not have a qualified DBA on site. You can sort of get away with MS-SQL without one. Joe ________________________________ From: "Bilinski, John" <[email protected]> To: [email protected] Sent: Tuesday, January 6, 2009 9:30:07 AM Subject: Oracle 10g vs. SQL 2005 for supporting ITSM 7.1 ** Developers and DBA's, I need your opinion on which database softwares would be better suited to have the Remedy AR System 7.1.0 and the entire ITSM Suite 7.0.3 installed in. I am not partial to either database software's for I have used both before but never in a multi-server clustered and replicated environment like this proposed system. Please, if could give your opinions for which database software would be the best choose for a multi-tiered Remedy server environment running MS Server 2003 64-bit OS and relying heavily on replication between 3 databases in a production. The system may have to support up to 900 support staff users and 100,000 non-support staff users. Here are the 2 databases software's we are looking at supporting: - Oracle 10g [Enterprise + RAC] - MS SQL 2005 [Enterprise + RAC] Thanks in advance . __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
