[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: need input about data migration after Upgrade


Hi All,


Thanks Misi.  Sorry for the delayed response.  I’ve been working feverishly and haven’t spent time on the arslist.  I thank you for your time and efforts hosting it.


Our data migration product does much more than simple data migration.  It allows you to change Support structures, Operating Companies, Categorizations etc. during the data migration as well as keeping a new system up to date with an old system. 


As a simple example, consider the product catalogue.  You may have 5 different BMC manufacturers and many times more that of product catalogue entries:  BMC, BMC Software, BMC Software Inc, and so on.  In the new system, you would have only one BMC manufacturer with all dependent data changed as needed.


As a more complex example, the migration package will move Change of type Release to the Release module.  Any tasks in the change become Activities.


Meta-Update can do anything – period.  It’s chief advantage is its ability to do complex things with no programming and especially no API skills.  Any ARS Developer / Admin should be able to do what they need to do with an hour introductory WebEx. 


Consider Meta-Archive – a completely configurable archive solution that 1) checks root associations (so that an Incident connected to an open change is NOT archived), and 2) can output to Archive forms, CSVs, HTML, another server instance.  In production use on ITSM 9.1, 8.1, 7.6.04. 


Consider that we had a customer who had all CIs as Computer Systems (due to a bad migration) and had worked these a year accumulating leases, changes, relationships, etc.  A Meta-Update script of 16 hours was able to move all this data to the proper set of classes.


Consider that a Proof of Concept script was able to change a mass of login ids in an automated way even using a separate SQL server to query so that indexes could be applied that were not desired in the production server. 


Many more examples and information about the data migration product available at www.softwaretoolhouse.com



Ben Chernys
Senior Software Architect


Canada / Deutschland
Mobile:    +49 171 380 2329   GMT - 7 + [ DST ]

Mobile     +1 403  554 0887
Web:         www.softwaretoolhouse.com

We are a BMC Technology Alliance Partner



Check out Software Tool House's free Diary Editor and our  Freebies Section for ITSM Forms and 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. 


Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as a complete tree and checking associatuions.  Archive output to different servers, HTML pages with links to attachments or archive forms.


Pre ITSM 9.1.02?  Clarify?  Roll your own?  No problem!

You can keep your valuable data!






From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: April-19-17 5:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: need input about data migration after Upgrade




RRR|Chive might help you. It is free to use but low level. You need to know exactly what you want to. It uses the modify-date of the records to find which ones to add/update/remove, so you need to update that column when working at DB-level. Alternatively you can skip updating the modify-date (C6) column and RRR|Chive will not touch that record as it would be considered the same in source/target. You did not say if the cleaning activity happened in the source or target environment...


You might also consider talking to Ben Chernys at http://www.softwaretoolhouse.com/ as he has ready made scripts for his commercial Meta-Update to do ITSM migrations. I have not tried it myself though, but Ben should be able to tell you what he can and can not do.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* 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

April 19, 2017 9:11 AM, "Amit B" <racconsult@gmail.com> wrote:


Hello All,

We are in the middle of upgrading our ITSM . I have one question about data migration. As we have opted parallel upgrade ,i mean we have build separate server and took DB backup from current prod and dump it on new server. So currently existing infra is up & running and lot of data cleanup is happening based on business requirement but this data cleanup is happening from DB. So my question is whether DDM will have ability to identify records got modified via DB ?


Amit B

_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_