SQL Server is cheaper and easier to manage. It works better when it comes to case sensitivity. For the amount of users you have, there are no performance advantages or anything when it comes to Oracle. Basically, Remedy works perfectly fine on both, but you should use whatever you and your DBAs are more comfortable with, and what works on the hardware and OS you are using (e.g. you can't run SQL Server on Linux but you can run Oracle.) Management should listen at least to the dollars involved if you are purchasing new licenses, as SQL Server Standard is a whole lot cheaper than Oracle.
Thanks, Shawn Pierson Remedy Developer | Energy Transfer -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra Sent: Friday, September 28, 2012 9:08 AM To: arslist@ARSLIST.ORG Subject: SQL or Oracle All, I am setting up a brand new ARS with ITSM. The big decision is whether to go with SQL or Oracle as the backend. I prefer SQL; management thinks Oracle. Without starting a frightening Friday foray on the List, does anyone (LOL) on the list have an opinion? I really need some feedback with the Pros & Cons of using either DB that I can take to my managers. So you know, the system is for an organization that will support about 3000 end users (Support staff plus customers). We have the entire ITSM suite to deploy which will be accomplished in stages. We will start with Asset and Incident Management then move onto Change and Release then to SRM. Anyone? Thank you, Sandra Hennigan Remedy Developer _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"