What you probably mean is that it takes more than a few points and clicks to do majority of the maintenance in Oracle while in MS-SQL, much of the work can easily be done with a few points and clicks.. MS-SQL does have a more user friendly GUI interfaces, which is possible to maintain without the need of a full time DBA. So if you want to get rid of your dependence on a DBA, MS-SQL may be a good way to go. This DB has got fairly robust over time. A little less than 10 years ago, I wouldn’t be saying the same thing..
Oracle however is one of the best DB’s that is capable of handling larger data volumes more efficiently. Yes it has its drawbacks with case sensitivity, but if that is not a major concern (because of the way your foundation data might be set up), then it is undoubtedly a better DB with slightly higher maintenance costs as it may require the need for a full time DBA if your Remedy Admins or developers do not have those skills.. Joe From: Jose Manuel Huerta Guillén Sent: Wednesday, September 05, 2012 5:18 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Oracle vs. SQL ** After dealing with MS SQL and Oracle, I can see two differences: - MS SQL case insensitive is easier to achieve. - Oracle admins are usually more "professionals" than MS SQL ones. This is not a fact, but a probability I found at my experience. What it isn't true is that case insensitive can only be achieved in MS SQL. I have an Oracle RAC configured for case insensitive and it performs perfectly. So, at the end, it is more about organization culture and religion than a technical decision. IMHO, I would choose MS SQL because the licensing cost. Invest the saved license cost in hardware and admin, and the result would be better. Finally the decision between enterprise and standard depends on the size of your ARS system. Normally the standard edition can fit for hundreds of users. But It would depend on the use that those users made on the database, and if the database server is to be shared with other applications. Also it's important your DBA opinion, since the enterprise edition has some features not available at the standard like increased management or BI options Regards, Jose Manuel Huerta http://theremedyforit.com/ On Wed, Sep 5, 2012 at 11:06 PM, Thad Esser <thad.es...@gmail.com> wrote: s me as funny criteria for determining which database to use, but I gues _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"