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 <javascript:> > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > ars...@arslist.org <javascript:>] On Behalf Of Joe Martin D'Souza > Sent: Friday, September 28, 2012 3:10 PM > To: ars...@arslist.org <javascript:> > 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 <javascript:> > 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 <javascript:>] On Behalf Of Joe Martin D'Souza > Sent: Friday, September 28, 2012 2:04 PM > To: ars...@arslist.org <javascript:> > 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 <javascript:> > 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 <javascript:>] On Behalf Of Hennigan, Sandra > Sent: Friday, September 28, 2012 9:08 AM > To: ars...@arslist.org <javascript:> > 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" > > _______________________________________________________________________________ > > > 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"