Just my 2 pence worth but also remember that most Oracle replication methods require the destination database to be in read only mode. Something the AR System can not run against.
Kind regards Danny From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bilinski, John Sent: 06 January 2009 19:30 To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, January 06, 2009 10:04 AM To: arslist@ARSLIST.ORG 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" <john.bilin...@usdoj.gov> To: arslist@ARSLIST.ORG 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"