Migrator is going to be a haphazard approach as you will run into issues if there are conflicts on things like the user/group forms, some objects doesn't migrate (core fields on display only forms), plus it will take a long time to move things in that way.
The best approach, in my experiences, is: 1. export the db from the old production system 2. import the db to the new db instance 3. Install ARS 7.5 on the new arserver and point it at the new db server; the installer should take care of the rest. This approach will take care of altering all the things in the db that are needed to run the newer version of ars, all your data will be there, and it will take much less time and be less problematic than going through the Remedy api. Some other things to check/consider when upgrading: - the character set of the new oracle instance; make sure you use what Remedy supports if youcheck plan on running in unicode (AL32UTF8). Many shops use other character sets (e.g., UTF8). - Make sure you install the 64-bit Oracle client Axton Grams On Fri, Sep 11, 2009 at 11:50 AM, Brittain, Mark <[email protected]> wrote: > After thinking about this some more, I have one question. What if the new box > has a different name? > > When we move to the new production box, this will likely not be an issue > because we will keep the same name. But while we are testing our process with > 2 development boxes they will have to have different names so they can both > be on the network. > > Of course if I could use Migrator then it would not be an issue. However it > makes no sense for me to pay a lot of money for something I will use for 30 > days. > > Thanks > Mark > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Grooms, Frederick W > Sent: Thursday, September 10, 2009 10:59 AM > To: [email protected] > Subject: Re: Moving ARS 6.3 -> ARS 7.5 > > Are you sticking with the same applications in Remedy? > > If so I would recommend building the new box, installing Oracle, copying the > data from Oracle 9 (I think the Oracle utility is called Data Pump or > something like that), and installing ARS 7.5 as an upgrade. > > Using the Oracle utility will also copy things like your Procedures/Functions > and dbLinks to the new database. > > The DBAs here used the utility when we moved our databases from a Sun RISC > cluster w/Oracle 9i to a Sun x86 cluster w/Oracle 10g with no problems. > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Brittain, Mark > Sent: Thursday, September 10, 2009 9:12 AM > To: [email protected] > Subject: Moving ARS 6.3 -> ARS 7.5 > > ** > HI All, > > I am planning on moving from ARS 6.3 on SunOS 5.9, Oracle 9.2 to ARS 7.5 > Oracle 11g, Linux 5 (64-bit). Thought is to completely build the new box, > install ARS 7.5 and the move the data over to the new server. > > Has anyone done this before? Any suggestions on the best way to move the > data? Is there a better way? > > Thanks > Mark Brittain > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > This e-mail is the property of NaviSite, Inc. It is intended only for the > person or entity to which it is addressed and may contain information that is > privileged, confidential, or otherwise protected from disclosure. > Distribution or copying of this e-mail, or the information contained herein, > to anyone other than the intended recipient is prohibited. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
