Hi, Why not import the required defs and data into your new ITSM-server? You could use RRR|Chive to copy your data to the new machine.
Depending on how the data is really needed, you could dump it to arx-files. You could then use something like RRR|ArxToHTML to create views of your tickets. Put it on a web-server and index the content. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Hello, > > We have put our old Remedy Legacy System ( 6.3) system in read only mode > after the ITSM launch last year in July. We are now working on > decommissioning the old Remedy system but we need to keep the data in the > Remedy system intact for auditing / reporting purpose. The version of the > Remedy we are running on is dependent upon PA-RISC processor which HP > doesn't sell any more. So if the hardware was to fail and we were beyond > vendor support , we would not be able to restore remedy on another HP > Server. > > So we are exploring options to pull Remedy report / data without going > through the application server. The data we are targeting is from Helpdesk > and Change forms and its associated join forms. > > One way to get the data from Oracle is via Oracle ODBC (DB is Oracle) and > as per our reporting team's suggestion creating reports using Oracle ODBC > from Crystal will not be feasible as some of the data stored in database > tables are in numbers. E.g date fields, date in Work log field and drop > down fields. > > Is there any better way ( using some tools / utilities) to pull this data > from AR Schemas on Oracle database? > > Did any of you face this scenario when your company was migrating from 6.3 > to 7.x? > > I would really appreciate for your valuable suggestion here. > > Note: Our current ARS version is 7.5 and ITSM version is 7.6.00 but in 2 > weeks time we will be on AR 7.6.04 SP1 and ITSM 7.6.04 SP1. Our new > database is oracle > > Thanks...Swanand > > _______________________________________________________________________________ > 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"