Sandra, Both SQL Server and Oracle are pretty stable.
I prefer Oracle because of the following reasons 1) Performs faster than MS SQL under ANY load especially when you have huge databases running huge transaction volumes. 2) Has more functionality than MS SQL - especially when it comes to fine-tuning performance or monitoring what is happening on the db in real-time. 3) It Runs on more OS'es than just (Mister Slow) Windows. e.g: Linux (When running on non-Windows OS'es (like Linux), your risk level for being exposed to viruses is a lot lower.) 4) MS has too much of a monopoly - Supporting the likes of Oracle ensures one vendor does not have a total monopoly. 5) Due to Oracle not being as easy to tamper with for non-dba's, you are ensured that only the correctly skilled professionals are working on it, reducing risk of outtages due to operator error. 6) All the reasons Axton and Joe mentioned as well. 7) Case sensitivity is not such a huge issue with Oracle, as is often thought. Any DBA worth his salt CAN set up your Oracle DB to be Case-Insensitive. We do use MS SQL a lot as well for smaller low-volume implementations where budgets are very limited and fast performance is not a priority requirement. So, to pick between the two, ask yourself this: 1) Do I want best possible DB performance and granular functionality and control, that is more difficult to maintain without a DBA, at a higher cost? OR 2) Do I want a lower cost DB with an easy-to-use GUI that is limited in functionality and will have slower performance? If you do not already have an Oracle DBA and your answer for Q2 is yes, then go MS-SQL, otherwise, go Oracle. Best Regards, Theo Sent from my Black/Silver Personal Computer .... “Try not to become a person of success, but a person of value.” – Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: 30 September 2012 05:43 To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle ** Some things I like with Oracle: - XMLGEN package: if you want to get at your AR data in xml format, this works great - Dynamic performance views: want to see what your database is, or was, doing? - Flashback capabilities: want to take a snapshot before major releases and fail back in a matter of minutes? - BCV: Want to get a copy of your database in minutes? - It runs on OS's that are not Windows (I don't care for MS as a server OS; it's my personal preference, but I loathe the mentality that a reboot is a cure-all; I like my machines to run like ... machines -- efficient, predictable, and reliable) - I can manage it without a GUI Maybe some of these things are available with MSSQL. I try to separate myself from MS technologies because they only tend to work with other MS technologies and I don't like to be boxed in. Axton Grams On Fri, Sep 28, 2012 at 4:03 PM, patchsk <vamsi...@gmail.com<mailto:vamsi...@gmail.com>> wrote: ** Yes it works. We do it all the time copying db from prod to pre-production environments. It is a standard task to dbas. No special instructions needed. On Friday, September 28, 2012 12:24:40 PM UTC-7, Hennigan, Sandra wrote: BMC guide speaks to SQL but not Oracle. Can a backup of Oracle be taken and moved to another environment then ARS be made to point to the database backup? Will this be a capability with Oracle? Thank you, Sandra Hennigan Remedy Developer Criminal Division | U.S. Department of Justice ☎ (202) 353-0557<tel:%28202%29%20353-0557> Mobile: 202-716-0848<tel:202-716-0848> sandra....@usdoj.gov<mailto:sandra....@usdoj.gov> -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:ars...@arslist.org] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 3:10 PM To: ars...@arslist.org<mailto:ars...@arslist.org> Subject: Re: SQL or Oracle I'm not quite sure I understood your question.. What exactly is your requirement? Joe -----Original Message----- From: Hennigan, Sandra Sent: Friday, September 28, 2012 2:28 PM Newsgroups: public.remedy.arsystem.general To: ars...@arslist.org<mailto:ars...@arslist.org> Subject: Re: SQL or Oracle Thank you, Lister. I also reviewed the archives. For you Oracle users, a question: Even with every best intention, keeping Support Group IDs, foundation data etc. matched between Test and Production is difficult so routinely, the production database is backed up and a copy moved to our test environment. Using SQL, this is a simple process. Is this an action I can take with Oracle? Sandra Hennigan Remedy Developer -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:ars...@arslist.org] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 2:04 PM To: ars...@arslist.org<mailto:ars...@arslist.org> Subject: Re: SQL or Oracle I agree about MS-SQL being maintenance light, cheap, and at the same time a fairly robust database, which has a winning point on case sensitivity.. But because of the nature of searches and the format data is stored in your organization, if case insensitivity isn't going to buy much and you'll already have a full time Oracle DBA, I would go with Oracle as Oracle tends to be more flexible on certain maintenance standpoints than MS-SQL can ever be to the best of my knowledge.. I'm not even a fully qualified Oracle DBA nor am I a fully qualified MS-SQL DBA, and I find Oracles scripting capacities far more superior than MS-SQL. For e.g. I have in the past been able to script oracle backups and restore, selecting specific parameters to export and import (only structures, only data, only certain tables or views, etc) in scripts that has given me the ability to pretty much replicate production databases minus all the application data.. I really do not think there is a way to do the same in MS-SQL, but then I could be wrong... I just may have not found a way to script that in MS-SQL... All in all I agree with most of the comments on this thread as well as one similar to this a few weeks ago, MS-SQL can be fairly cheaper and easier to maintain than Oracle which would need an expensive full time DBA.. Joe -----Original Message----- From: Pierson, Shawn Sent: Friday, September 28, 2012 11:23 AM Newsgroups: public.remedy.arsystem.general To: ars...@arslist.org<mailto:ars...@arslist.org> Subject: Re: SQL or Oracle 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:ars...@arslist.org] On Behalf Of Hennigan, Sandra Sent: Friday, September 28, 2012 9:08 AM To: ars...@arslist.org<mailto:ars...@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<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://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<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://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"