I’ve actually done a migration of the data using web services. Built a web service to get the records from Remedy and then built ‘read-only’ archive tables in the new system, pulled the data across into those tables.
Attachments are a bit of a different story – used outbound email to transfer those across to the new system. Need a bit of info in the email body to identify what the attachment relates to. It’s really a cost matter – whether it’s less costly to keep the database / data around and accessible or just archive it in the new system (In a db that’s already being maintained) vs building the web services to extract / consume the records. From: ARSList <arslist-boun...@arslist.org> On Behalf Of Jason Miller Sent: Friday, August 16, 2019 9:56 AM To: ARSList <arslist@arslist.org> Subject: Re: [EXTERNAL] Re: Old Remedy 6.3 data Regarding attachments, LJ built a tool for that :) http://remedylegacy.com/tools/db-attachments/ Jason On Fri, Aug 16, 2019 at 8:38 AM Kelly Logan <kelly.lo...@raptek.com <mailto:kelly.lo...@raptek.com> > wrote: Going back to the original description, an archive system that is queried a couple of times a year, I would agree with LJ LongWing that a good fit is to approach this from the database side and switch your Remedy queries to database queries. If you can keep the entire database intact that would be the easiest method. While Remedy is still up I would recommend taking a list of the queries you have run over the past years and take some time learning to duplicate them with direct database queries, in particular noting relationships that are relevant (ticket to work info, tasks, etc) so that you can access all the data your users require easily. If you have a separate reporting solution, you could take the most common queries and create reports based on them to make things easier, perhaps even to the point of publishing the reports with dynamic parameters like Start and End dates so that users can run the reports themselves when they need the information. Or some basic scripting in a handy language you use at your company could do the same job with a web form that runs a set of canned database queries. Attachments would be an extra challenge. If your archive queries include pulling attached files from old tickets then you'll need to learn how to translate the B/CLOB data to recreate the file. Again, there's info on how to do this and could probably be automated without too much trouble. If you can't keep the entire database and have to work off a smaller set of data, then I would approach this like a regular Remedy archive project - review the forms and data, determine which are necessary and what their relationships are and then export them to a simpler solution (another database, flat file, etc). On Thu, Aug 15, 2019 at 5:51 PM Ian.Trimnell <ian.trimn...@open.ac.uk <mailto:ian.trimn...@open.ac.uk> > wrote: Hi Claire, Same here. We had our Remedy system (7.5) on a Windows 2003 server which had to go. The last supported part of AR System – a custom IT Ordering System – was moved to a SCSM-based setup earlier this year so I was forced to shut it all down. (We had been running since 1998 on Windows, moving to new servers as required, and had stopped paying for maintenance renewal for about 5 years or more so we couldn’t move to a newer version of AR System.) The SQL Server was also 2003 so was removed as well. I still receive requests for records of the old systems, all custom built in house, and I have migrated a number of sections onto a MySQL server I control. The worst bit comes in building a suitable interface – nothing seems to beat the AR System way of doing things! There was nothing I could find which would fit the job, apart from converting the database (had both ARX files and an SQL dump) and building any necessary front-ends. The only one I’ve had to do fully was a user management system – keeping track of any email addresses and user-ids allocated to staff. Everything else is handled by database queries (phpMyAdmin helps as a GUI to MySQL but sometimes using the mysql command line is eminently suitable! Sorry, not a lot of help, but good luck in finding something which suits your particular situation. Ian ---------- Ian Trimnell, Systems Programmer, Information Technology The Open University, Milton Keynes, UK Phone: 01908 653741 web: <http://www.open.ac.uk/> http://www.open.ac.uk From: ARSList <arslist-boun...@arslist.org <mailto:arslist-boun...@arslist.org> > on behalf of "Sanford, Claire" <claire.sanf...@memorialhermann.org> Reply to: ARSList <arslist@arslist.org <mailto:arslist@arslist.org> > Date: Thursday, 15 August 2019 at 20:23 To: ARSList <arslist@arslist.org <mailto:arslist@arslist.org> > Subject: RE: [EXTERNAL] Re: Old Remedy 6.3 data Yes, we moved to another solution. I enjoy learning the new stuff, but I miss the comfort of what I knew like the back of my hand. We have people come back for change records etc for legal things periodically and have to keep it. Thank you! Claire From: ARSList <arslist-boun...@arslist.org <mailto:arslist-boun...@arslist.org> > On Behalf Of LJ LongWing Sent: Thursday, August 15, 2019 2:04 PM To: ARSList <arslist@arslist.org <mailto:arslist@arslist.org> > Subject: [EXTERNAL] Re: Old Remedy 6.3 data Carina, If I'm not mistaken, they aren't using Remedy anymore (moved to another solution)....so Remedy for them is just in mothballs wanting/needing as little time/effort as possible. On Thu, Aug 15, 2019 at 12:54 PM Burns, Carina <carina.bu...@risd.org <mailto:carina.bu...@risd.org> > wrote: If it’s a custom app, why not import the defs with Designer Studio then DDM the records off the old ARSystem with migrator? Just be sure your database/system can handle that volume of data. I did that for our legacy custom help desk app (built on 4.3 and upgraded thru 8.1) and it’s all living happily alongside my ITSM/ServiceDesk/Smartit/DWP apps on my 19.02 box. I just did a basic “main menu” with “open form” active link buttons to select the old app forms. I also created a filter restricting record modifies/submits. If it’s an old ITSM records, could you maybe still migrate/DDM the data and put them into archive? I don’t know If they’d be viewable with whatever level of ITSM you’re currently running. From: ARSList <arslist-boun...@arslist.org <mailto:arslist-boun...@arslist.org> > On Behalf Of LJ LongWing Sent: Thursday, August 15, 2019 1:36 PM To: ARSList <arslist@arslist.org <mailto:arslist@arslist.org> > Subject: Re: Old Remedy 6.3 data Your option I think is to simply stop using Remedy at that point and just access the data at the DB level....if you want to use the Remedy Application, you need the Remedy application though. On Thu, Aug 15, 2019 at 12:12 PM Sanford, Claire <claire.sanf...@memorialhermann.org <mailto:claire.sanf...@memorialhermann.org> > wrote: Hey Old Friends! We have an old Remedy server that is strictly an archive. We have people ask for ticket info a few times a year or so. We have been told that we have to upgrade the server. Since the old server is 32bit and the new one is 64bit, they are telling me I have to reinstall the apps that are on the server. Does anyone have a front end for an old Remedy system that does not entail reinstalling the apps? Claire Sanford ISD ITCC Technical Engineering Lead Application Analyst Memorial Hermann, Memorial City Medical Plaza North 920 Frostwood Houston, TX 77024 P 713.338.6035 claire.sanf...@memorialhermann.org <mailto:claire.sanf...@memorialhermann.org> -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=cBOA5YEoZuz9KdLvh38YxdrPtfJt83ckXekfBgq5xB0&r=TjDOQeE84FB3IkKBOKJ7-reBz8qKDLQv4sMWw_GFxq4ypeuVm4ZMlj00hGeKuFbo&m=MALDIa38iVr7jw6M0kmOIiUqkQR7InXApIQLtOgk3So&s=2xi3wUi3t2JqcEMVs33r5X7MTz2H48JjSisFf6Jm8zs&e=> -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=cBOA5YEoZuz9KdLvh38YxdrPtfJt83ckXekfBgq5xB0&r=TjDOQeE84FB3IkKBOKJ7-reBz8qKDLQv4sMWw_GFxq4ypeuVm4ZMlj00hGeKuFbo&m=MALDIa38iVr7jw6M0kmOIiUqkQR7InXApIQLtOgk3So&s=2xi3wUi3t2JqcEMVs33r5X7MTz2H48JjSisFf6Jm8zs&e=> -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- Kelly Logan | Senior Consultant 313-651-7169 | kelly.lo...@raptek.com <mailto:kelly.lo...@raptek.com> RAPID Technologies <http://www.raptek.com/> www.raptek.com -- ARSList mailing list ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist