Thanks for response Sabyson I worked as you said but when I query any records it is taking a lot of time some times time out error because I need to get related tasks as well and moving the tables which my manger don't want to do it. So i am trying with stored proc to set a parameter value to get the records but is it possible to display the related tasks in the task tab in CHG:Change form.
Sabyson Fernandes wrote: > > You can look into creating a Database link between the 6.3 ARSystem > database and the 7.5 ARSystem database. Then create a database SQL view in > the 7.5 database that points to the 6.3 database change form. You can then > create a view form that points to this DB view and you can access the 6.3 > change data from within Remedy 7.5 . > > Sometimes DB links are slow, so for best results I would just copy the > relevant tables into a separate database within the same database instance > as your 7.5 database and create the view form on top of that. > > Hope this helps. > > Saby > > --- On Sat, 2/26/11, gok's <[email protected]> wrote: > >> From: gok's <[email protected]> >> Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help >> me with any ideas >> To: [email protected] >> Date: Saturday, February 26, 2011, 8:15 PM >> My manager didn't want to move the >> data structures in to the 7.5 database he >> want it keep out side but .....user want see only >> CHG:Change tickets from >> that 6.3 data....... >> >> I want to see only to view the CHG:Change tickets in 7.5 >> user tool. >> >> >> >> >> >> Joe Martin D'Souza wrote: >> > >> > If the database doesn't have a running AR Server, why >> not just upgrade it >> > to >> > AR System Server 7.5 by installing one and choosing >> the upgrade option >> > against that database? >> > >> > That way the data structures will be of the same >> version.. >> > >> > I do not have a complete idea of what you are trying >> to achieve - meaning >> > if >> > you want to access this database to just view or >> modify or ?? So if you >> > can >> > give a little more of what you are trying to achieve I >> or someone here >> > might >> > have some better views on how to help you.. >> > >> > Joe >> > >> > -----Original Message----- >> > From: gok's >> > Sent: Saturday, February 26, 2011 1:20 PM Newsgroups: >> >> > public.remedy.arsystem.general >> > To: [email protected] >> > Subject: trying to query ARRemedy 6.3 data from >> ARserver 7.5.....help me >> > with any ideas >> > >> > Hi All, >> > >> > I am trying to query or to search by based on CHG >> request id from ARSystem >> > 6.3 to ARSystem 7.5. here ARSystem_6_3 database didn't >> have any ARServer >> > and >> > Mid-tier so I am trying to use Java API ..Here I want >> some information >> > regarding whether I can get the chg ticket information >> like related tasks >> > and attachments to ARSystem 7.5. >> > >> > >> > Thanks for replies >> > >> > >> _______________________________________________________________________________ >> > UNSUBSCRIBE or access ARSlist Archives at >> www.arslist.org >> > attend wwrug11 www.wwrug.com ARSList: "Where the >> Answers Are" >> > >> > >> >> -- >> View this message in context: >> http://old.nabble.com/trying-to-query-ARRemedy-6.3-data-from-ARserver-7.5.....help-me-with-any-ideas-tp31021215p31021745.html >> Sent from the ARS (Action Request System) mailing list >> archive at Nabble.com. >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug11 www.wwrug.com ARSList: "Where the Answers >> Are" >> > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > -- View this message in context: http://old.nabble.com/trying-to-query-ARRemedy-6.3-data-from-ARserver-7.5.....help-me-with-any-ideas-tp31021215p31035969.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
