FW: SQL or Oracle

2012-10-05 Thread Jim Coryat (jcoryat)
-Original Message- From: Hullule, Kiran [mailto:kiran_hull...@bmc.com] Sent: Thursday, October 04, 2012 6:53 AM Subject: Re: SQL or Oracle Yes, and that's only applicable to Oracle database. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist

Re: SQL or Oracle

2012-10-04 Thread Hennigan, Sandra
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

Re: SQL or Oracle

2012-10-04 Thread Hullule, Kiran
(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

Re: SQL or Oracle

2012-10-04 Thread Lou
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

Re: SQL or Oracle

2012-10-04 Thread Hullule, Kiran
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

Re: SQL or Oracle

2012-10-01 Thread Theo Fondse
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

Re: SQL or Oracle

2012-09-29 Thread Axton
...@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

SQL or Oracle

2012-09-28 Thread Hennigan, Sandra
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

Re: SQL or Oracle

2012-09-28 Thread Rick Cook
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

Re: SQL or Oracle

2012-09-28 Thread Grooms, Frederick W
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

Re: SQL or Oracle

2012-09-28 Thread David Durling
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

Re: SQL or Oracle

2012-09-28 Thread Pargeter, Christie :CO IS
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

Re: SQL or Oracle

2012-09-28 Thread David Durling
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

Re: SQL or Oracle

2012-09-28 Thread Carlos Checa
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

Re: SQL or Oracle

2012-09-28 Thread Longwing, LJ CTR MDA/IC
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

Re: SQL or Oracle

2012-09-28 Thread Pierson, Shawn
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

Re: SQL or Oracle

2012-09-28 Thread Joe Martin D'Souza
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

Re: SQL or Oracle

2012-09-28 Thread John Sundberg
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

Re: SQL or Oracle

2012-09-28 Thread Hennigan, Sandra
, 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

Re: SQL or Oracle

2012-09-28 Thread Joe Martin D'Souza
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

Re: SQL or Oracle

2012-09-28 Thread Hennigan, Sandra
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

Re: SQL or Oracle

2012-09-28 Thread Joe Martin D'Souza
, 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

Re: SQL or Oracle

2012-09-28 Thread patchsk
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