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"
