I’ve got to second Ben here. This project is not for the faint-hearted, but his meta-update product does make data migration possible. I really don’t think there’s another practical way. There are very painstaking ways to do this, but have a look at meta-update. Transactional data is a very tangled web. My reporting product will show you how crazy the situation it is, but we can’t fix it.
In fact, I’ll add that 80% of companies that have left BMC Remedy to move to ServiceNow did so because of upgrade costs OR pre-ITSM 7.6.4 usability. For our latest product demonstrations, please visit – http://www.youtube.com/user/northcraftanalytics Lee Cullom | Northcraft Analytics IT Metrics Specialist | Business Intelligence for ITSM Direct - 678-438-7244 | lee.cul...@northcraftanalytics.com<mailto:lee.cul...@northcraftanalytics.com> Main - (678) 664-ITSM [Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcSo4qhIq-bDh4Z1UzKXet0tiAZqqejjd1BT8lVOHdrzZQwqeZun]<http://www.linkedin.com/in/leecullom>[Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcSWE5AoudybparNXkh21Br8ZWGNBqdra5ylZ63igCoZ36o5b5iFEA]<http://twitter.com/#!/NorthcraftIT> http://www.northcraftanalytics.com<http://www.northcraftanalytics.com/> THE CONTENTS OF THIS EMAIL, INCLUDING THE CONTENTS OF ANY ATTACHMENTS HERETO, CONSTITUTES “CONFIDENTIAL INFORMATION” AND IS SUBJECT TO A CONFIDENTIALITY AND NON-DISCLOSURE AGREEMENT BETWEEN THE RECIPIENT AND NORTHCRAFT ANALYTICS LLC. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: Thursday, June 27, 2013 10:55 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrade from v5.1.2 to v8.1 ** The upgrade from HPD 5.1.2 to ITSM 7+ is difficult but we have done it and have Meta-Update scripts available to do this. Meta-Update can also be used to migrate the limited asset data available on 5 to the CMDB. These Meta-Update scripts will convert tickets as needed, ensuring attachments are moved to the appropriate work logs, the notes field are moved to multiple work log entries, etc. People can also be migrated with some rules in place to allow for the different permissions model. I would expect that the easiest way would be to put up a new server with a new db and then migrate the data from 5 to 8. Should you wish to clean this data or reorganize categorizations this is possible during the migration. Please contact me off-list if interested in pursuing this option further. Cheers Ben Chernys Senior Software Architect [logoSthInc-sm] Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com<mailto:Ben.Chernys_AT_softwaretoolhouse.com> Web: www.softwaretoolhouse.com<http://www.softwaretoolhouse.com/> We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and out Freebies Section for a ITSM 7.6.04 and 8.0.0 Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Raj Sent: June-27-13 16:42 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Upgrade from v5.1.2 to v8.1 ** Hello All, We are trying to perform an upgrade of our Remedy Instance on v5.01.01 to v8.1. So far we have upgraded ARS from v5.1.2 > v6.3 > v7.1 > v7.6.04.(Solaris) on Dev Environment as a proof of concept. We are targeting to Upgrade to v8.1 and also to move to Linux(VMware ESX). To accomplish this here's what we are trying to do: 1. Upgrade ARS to v7.6.04(Solaris), take DB(10g) copy 2. Install a fresh ARS of v7.6.04(Linux) + DB(10g) 3. Drop DB of Step 2 + Attach DB copy from Step 1(so we will have a ARS v7.6.04 with Linux on 10g DB) 4. Upgrade DB to 11g 4. Run upgrade install from ARS v7.6.04 to v8.1 Based on the above approach/ steps I have few questions: 1. Is the above approach feasible?, as the aim for our upgrade is to bring our Remedy instance to a supported version. ARS upgrade from v5.1.2 to v8.1. Also, we would like to move away from Unix/Solaris platform to Linux VM platform. 2. We also have ITSM 5.6/Remedy HelpDesk v5.1.2 - How do we handle this? As for now, we are only thinking of upgrading ARS not ITSM. 3. Also, my understanding is v7.5 onwards, there has been drastic changes. Any caveats of losing our customizations(Customization on HPD as well as Custom applications we have in place)? How do we handle these? 4. Dev Server - As a proof of concept on our Dev Server, we upgraded ARS from v5.1.2 to v7.6.04 so far. Working on to upgrade to v8.1 now. 5. DB from non-unicode to unicode - Our Dev DB was already Unicode. Whereas our Prod DB is non -unicode, so at what point do we have to convert from non-unicode to Unicode(before running v6.3 Upgrade install)? Source - ARS v5.1.2 + ITSM v5.6(HelpDesk v5.1.2) + Custom/Home grown apps. Destination/Target - ARS v8.1 + ITSM v5.6(HelpDesk v5.1.2) if supported or ITSM v8,1(Service Desk) + Custom/Home grown apps. Environment Information: Current Production: Environment Info: AR Server Version : 5.01.02 Patch 1313 Hardware : sun4u Operating System : SunOS 5.10 DB : SQL -- Oracle DB Version : 10.2.0.5.0 - 64bi Current Development (where we are running ARS Upgrade Installs): Environment Info: AR Server Version : 7.6.04 SP4 201209051922 Hardware : sun4u Operating System : SunOS 5.10 DB : SQL -- Oracle DB Version : 10.2.0.5.0 - 64bi Does the above approach feasible? I would highly appreciate any help(practical lessons, gotchas, caveats, etc) you can provide. Regards, Raj _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.jpg>>
<<inline: image002.jpg>>
<<inline: image003.jpg>>
