BMC has been good at not deleting any fields from version to version. They have been adding lots of fields. I would stick to ARX files. As long as you add your custom fields with the same field number Automap will match them up.
Closed records should not be edited and that only leaves Open records to clean up. There may be some cleanup of records that historical reports may need for consistency. Dale Jones DCS Raleigh, NC 919-523-6034 ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of BradRemedy [bradrem...@gmail.com] Sent: Wednesday, January 15, 2014 12:10 AM To: arslist@ARSLIST.ORG Subject: Re: Migration of Foundation and Historical Data ITSM 7.6 to ITSM 8 - Using Spoon ** Hi With all the various modules, I would say we have < 1 million combined records with around 200 new records being created via SRM on a daily basis (so around 6000 new calls a month). Not a massive system to other installations however it is used extensively in our organization. I was thinking of using ARX files, however wasn't sure on the database structure between the versions and if it would present other problems. On Wed, Jan 15, 2014 at 7:00 AM, Dale Jones <d...@dcshq.com<mailto:d...@dcshq.com>> wrote: ** Brad, You have multiple options to move data, I would first like to ask a couple questions. Transactional Data - Number of INC, CHG, SRM, PBM, Task. Just ballpark 100K or > million. Volume per month 50K, 100K or >million Number of open tickets INC, CHG, SRM, PBM, Task I have leveraged ARX exports and imports for most of my customers transactional data migrations to 8.1 (1 initial move then multiple Delta moves up to Go Live weekend. Added a handful of cleanup filters and an escalation or two to trigger cleanup. The main cleanup is on open records that need to modified and will trip validation filter errors. Also have added an exclusion to some existing validation filters (ie 'Submit Date' > "01/01/14") (Go Live date 01/01/14 example) Dale Jones DCS Raleigh, NC 919-523-6034<tel:919-523-6034> ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] on behalf of BradRemedy [bradrem...@gmail.com<mailto:bradrem...@gmail.com>] Sent: Tuesday, January 14, 2014 11:22 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Migration of Foundation and Historical Data ITSM 7.6 to ITSM 8 - Using Spoon ** Hi All Hope everyone is well. We are busy with our upgrade to ITSM 8 and have setup a completely new environment which will host the Version 8 applications. We are currently running Remedy 7.6 P003 with ITSM 7.6 and SRM 7.6. The new environment has been setup and configured and is working perfectly and we now come to the task of migrating the data from ITSM 7.6 to the new ITSM 8 environment. For now, we are focusing on the foundation data as that is the most important part and I was wondering how everyone who has done this upgrade has managed to move their data over. I was looking at using the spreadsheets, however it is alot of admin work and with any data updates or changes on our currently live 7.6 environment, we would need to make sure that we apply those updates to the version 8 environment. Ideally, we would like a automated solution / scripted solution that we can run which would update the data and keep the new environment in sync. It was suggested by another developer that we look at possibly using the Atrium Integration Spoon application to do this data migration and that we create a transformation job which we can re-run etc. Has anyone done this before? If not, would you please share how your company / project was able to migrate their data? Any assistance would be greatly appreciated. Thanks Brad _ARSlist: "Where the Answers Are" and have been for 20 years_ _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"