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 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"

Reply via email to