Re: SQL or Oracle
Yes, and that's only applicable to Oracle database. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Lou Sent: Thursday, October 04, 2012 6:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle You have to rebuild your ootb indexes to inlude case insensitive otherwise the bmc indexes will not be used. On Oct 4, 2012, at 8:38 AM, "Hullule, Kiran" wrote: > Case insensitive searches can perform very slows and can cause performance > bottleneck at the remedy application layer as case insensitive queries may > cause full table scan over unique index scan, I would go for Oracle. > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Friday, September 28, 2012 8:06 PM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > There was a recent discussion on this, if you check out the list archives. > > I'm not a dba, but one thing I'm looking forward to with MS SQL, if we move > to it from Oracle, is the case-insensitive searching without having to do any > special setup on the db side. > > David > > David Durling > University of Georgia > >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W >> Sent: Friday, September 28, 2012 10:25 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: SQL or Oracle >> >> Oracle is not bad either. Usually I ask what does your company support >> most. If you have better people for Oracle then choose Oracle, same goes >> for MS-SQL. >> >> Fred >> >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook >> Sent: Friday, September 28, 2012 9:22 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: SQL or Oracle >> >> ** >> The question I find most relevant is what platform your organization has the >> resources to support. Most of us can handle most day to day MSSQL >> tasks. Not so with Oracle, which requires someone trained and experienced. >> Rick >> >> -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" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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"
Re: SQL or Oracle
You have to rebuild your ootb indexes to inlude case insensitive otherwise the bmc indexes will not be used. On Oct 4, 2012, at 8:38 AM, "Hullule, Kiran" wrote: > Case insensitive searches can perform very slows and can cause performance > bottleneck at the remedy application layer as case insensitive queries may > cause full table scan over unique index scan, I would go for Oracle. > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Friday, September 28, 2012 8:06 PM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > There was a recent discussion on this, if you check out the list archives. > > I'm not a dba, but one thing I'm looking forward to with MS SQL, if we move > to it from Oracle, is the case-insensitive searching without having to do any > special setup on the db side. > > David > > David Durling > University of Georgia > >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W >> Sent: Friday, September 28, 2012 10:25 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: SQL or Oracle >> >> Oracle is not bad either. Usually I ask what does your company support >> most. If you have better people for Oracle then choose Oracle, same goes >> for MS-SQL. >> >> Fred >> >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook >> Sent: Friday, September 28, 2012 9:22 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: SQL or Oracle >> >> ** >> The question I find most relevant is what platform your organization has the >> resources to support. Most of us can handle most day to day MSSQL >> tasks. Not so with Oracle, which requires someone trained and experienced. >> Rick >> >> -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" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: SQL or Oracle
Case insensitive searches can perform very slows and can cause performance bottleneck at the remedy application layer as case insensitive queries may cause full table scan over unique index scan, I would go for Oracle. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Friday, September 28, 2012 8:06 PM To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle There was a recent discussion on this, if you check out the list archives. I'm not a dba, but one thing I'm looking forward to with MS SQL, if we move to it from Oracle, is the case-insensitive searching without having to do any special setup on the db side. David David Durling University of Georgia > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W > Sent: Friday, September 28, 2012 10:25 AM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > Oracle is not bad either. Usually I ask what does your company support > most. If you have better people for Oracle then choose Oracle, same goes > for MS-SQL. > > Fred > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook > Sent: Friday, September 28, 2012 9:22 AM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > ** > The question I find most relevant is what platform your organization has the > resources to support. Most of us can handle most day to day MSSQL > tasks. Not so with Oracle, which requires someone trained and experienced. > Rick > > -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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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"
Re: SQL or Oracle
Thank you everyone that replied. I appreciate the assistance. Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: Monday, October 01, 2012 6:16 AM To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle ** 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 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 Mobile: 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...
Re: SQL or Oracle
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 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 Mobile: 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
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 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 >> Mobile: 202-716-0848 >> >> 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 >> 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 >> 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 >> 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 Newsgr
Re: SQL or Oracle
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 > Mobile: 202-716-0848 > > 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 > 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 > 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 > 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 > 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 > 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. > >
Re: SQL or Oracle
Absolutely, with even a higher degree of control if you do scripted backup and restore.. In the earlier email (2 or 3 emails ago on this thread) I mentioned you can specify while exporting what exactly you want to export.. create exceptions, inclusions, rules, etc. (using .par files) and get a dump or a set of dumps of exactly the content you want to that you can import into the other database in another environment.. As long as all other parameters (ARS version, OS version, DB client version, etc.) are constant, it works.. The advantage of this is if you have a 20 Gig database that takes 10 hours to export and import, and you just want to rebuilt production to a test or a dev environment, you can skip vast amounts of data, cutting the export and import time from those 10 hours to maybe a few minutes.. Joe -Original Message- From: Hennigan, Sandra Sent: Friday, September 28, 2012 3:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle 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 Mobile: 202-716-0848 sandra.henni...@usdoj.gov -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 3:10 PM To: arslist@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: arslist@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:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 2:04 PM To: arslist@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: arslist@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: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
Re: SQL or Oracle
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 Mobile: 202-716-0848 sandra.henni...@usdoj.gov -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 3:10 PM To: arslist@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: arslist@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:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 2:04 PM To: arslist@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: arslist@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: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
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: arslist@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:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 2:04 PM To: arslist@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: arslist@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: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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at ww
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:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Friday, September 28, 2012 2:04 PM To: arslist@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: arslist@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: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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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"
Re: SQL or Oracle
I don't hear any real complaints from MSSQL users. I do hear real complaints from Oracle (case sensitivity). -John On Fri, Sep 28, 2012 at 9:08 AM, Hennigan, Sandra wrote: > 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" > -- *John Sundberg* Kinetic Data, Inc. "Your Business. Your Process." *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* * * 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
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: arslist@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: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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
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: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"
Re: SQL or Oracle
Sandra, I would say that the argument between the two is almost moot. You should go with whatever DB your organization/company has resources to support properly. Properly being the key word there. I personally feel MSSQL is 'easier' to run without a qualified DBA than Oracle is, but both are easy to work with when there is a qualified DBA -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra Sent: Friday, September 28, 2012 8: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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: SQL or Oracle
I prefer SQL El 28/09/2012 16:43, "David Durling" escribió: > Though I have to say that Fred's point makes a lot of sense - you need > someone around who knows how to handle the database! > > David D. > > > -Original Message- > > From: David Durling > > Sent: Friday, September 28, 2012 10:36 AM > > To: 'arslist@ARSLIST.ORG' > > Subject: RE: SQL or Oracle > > > > There was a recent discussion on this, if you check out the list > archives. > > > > I'm not a dba, but one thing I'm looking forward to with MS SQL, if we > move > > to it from Oracle, is the case-insensitive searching without having to > do any > > special setup on the db side. > > > > David > > > > David Durling > > University of Georgia > > > > > -Original Message- > > > From: Action Request System discussion list(ARSList) > > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W > > > Sent: Friday, September 28, 2012 10:25 AM > > > To: arslist@ARSLIST.ORG > > > Subject: Re: SQL or Oracle > > > > > > Oracle is not bad either. Usually I ask what does your company > support > > > most. If you have better people for Oracle then choose Oracle, same > > > goes for MS-SQL. > > > > > > Fred > > > > > > > > > -Original Message- > > > From: Action Request System discussion list(ARSList) > > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook > > > Sent: Friday, September 28, 2012 9:22 AM > > > To: arslist@ARSLIST.ORG > > > Subject: Re: SQL or Oracle > > > > > > ** > > > The question I find most relevant is what platform your organization > > > has the resources to support. Most of us can handle most day to day > > > MSSQL tasks. Not so with Oracle, which requires someone trained and > > experienced. > > > Rick > > > > > > -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" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.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"
Re: SQL or Oracle
Though I have to say that Fred's point makes a lot of sense - you need someone around who knows how to handle the database! David D. > -Original Message- > From: David Durling > Sent: Friday, September 28, 2012 10:36 AM > To: 'arslist@ARSLIST.ORG' > Subject: RE: SQL or Oracle > > There was a recent discussion on this, if you check out the list archives. > > I'm not a dba, but one thing I'm looking forward to with MS SQL, if we move > to it from Oracle, is the case-insensitive searching without having to do any > special setup on the db side. > > David > > David Durling > University of Georgia > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W > > Sent: Friday, September 28, 2012 10:25 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: SQL or Oracle > > > > Oracle is not bad either. Usually I ask what does your company support > > most. If you have better people for Oracle then choose Oracle, same > > goes for MS-SQL. > > > > Fred > > > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook > > Sent: Friday, September 28, 2012 9:22 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: SQL or Oracle > > > > ** > > The question I find most relevant is what platform your organization > > has the resources to support. Most of us can handle most day to day > > MSSQL tasks. Not so with Oracle, which requires someone trained and > experienced. > > Rick > > > > -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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: SQL or Oracle
I usually prefer SQL because of the Case Sensitive nature of Oracle. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 28, 2012 7:25 AM To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle Oracle is not bad either. Usually I ask what does your company support most. If you have better people for Oracle then choose Oracle, same goes for MS-SQL. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Friday, September 28, 2012 9:22 AM To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle ** The question I find most relevant is what platform your organization has the resources to support. Most of us can handle most day to day MSSQL tasks. Not so with Oracle, which requires someone trained and experienced. Rick -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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: SQL or Oracle
There was a recent discussion on this, if you check out the list archives. I'm not a dba, but one thing I'm looking forward to with MS SQL, if we move to it from Oracle, is the case-insensitive searching without having to do any special setup on the db side. David David Durling University of Georgia > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W > Sent: Friday, September 28, 2012 10:25 AM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > Oracle is not bad either. Usually I ask what does your company support > most. If you have better people for Oracle then choose Oracle, same goes > for MS-SQL. > > Fred > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook > Sent: Friday, September 28, 2012 9:22 AM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > ** > The question I find most relevant is what platform your organization has the > resources to support. Most of us can handle most day to day MSSQL > tasks. Not so with Oracle, which requires someone trained and experienced. > Rick > > -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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: SQL or Oracle
Oracle is not bad either. Usually I ask what does your company support most. If you have better people for Oracle then choose Oracle, same goes for MS-SQL. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Friday, September 28, 2012 9:22 AM To: arslist@ARSLIST.ORG Subject: Re: SQL or Oracle ** The question I find most relevant is what platform your organization has the resources to support. Most of us can handle most day to day MSSQL tasks. Not so with Oracle, which requires someone trained and experienced. Rick -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"
Re: SQL or Oracle
The question I find most relevant is what platform your organization has the resources to support. Most of us can handle most day to day MSSQL tasks. Not so with Oracle, which requires someone trained and experienced. Rick On Sep 28, 2012 7:18 AM, "Hennigan, Sandra" wrote: > 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" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"