Could you provide your environment details please. This would help us to better provide you with options that you can persue. The response time over a database link/linked server is dependent on network bandwidth and what your crietria for looking up the change record is. Do you search by the Change Request id, or are you searching by some other field. What happens if you just try to pull the change without its related tasks? To answer your question on the tasks, you can access the data the same way as in change. You can then create a table field on the view form that displays your changes to only view tasks related to that change. I still recommend making a copy of the relevant data and storing it locally. Try to convince your manager about the benfits of doing this. You do not need the entire ARSystem database from 63, but only pick the tables that have the relevant data e.g. the change and tasks table from 63 and copy the data to the 75 database instance. The tables can be stored in a seperate database (ARS63CHGData) and so your manager need not worry that the AR System database is being modified outside of Remedy. If you still get push back ask the following questions: 1. What happens if and when the ARS 63 database is retired 2. Is it not better that the DBA's have one less database to support 3. Easier development with a local copy of the data as you do not need to check if the remote database is up when querying the data from the 63 database. Saby
From: gok's <[email protected]> To: [email protected] Sent: Mon, February 28, 2011 3:45:48 PM Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas 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" _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"
