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> 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 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. >> >> 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<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" >> >> ______________________________**______________________________**___________________ >> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"