Re: [Non-DoD Source] Re: need input about data migration after Upgrade
Hell Misi, This nice insights. This is really helpful to me. Regards, Amit B A On Thu, Apr 20, 2017 at 2:30 PM, Misi Mladoniczky wrote: > ** > Hi, > > One big difference between DDM and RRR|Chive is that DDM just finds all > records after the date/time you specify and transfer these records. > > RRR|Chive will pull all recordids and modify-dates from both system and > then do transfer/delete as appropriate. No need to specify a date. > > Because of this it is easy to use to restore a system after, for example, > testing. > > I have been playing with the idea of using the DDM mapping files in > RRR|Chive, but have not come around to doing this. So you are pretty much > on your own and need to do the mapping yourself. > > I am not 100% sure about this, but I think that DDM will not copy data on > custom fields you have added yourself automatically. > > I have another tool I like to use when planning migrations to new > application versions, and this is RRR|DefFieldDiff that will give you an > excel sheet of all changed data fields. This makes it easy to find > differences and plan your data massaging. > > 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 2:39 PM, "Murnane, Phil" <%22Murnane,%20phil%22%20%3cphil.murn...@windward.com%3E>> wrote: > > We've used DDM and RRR|Chive successfully on various projects. Misi's tool > is scriptable and very fast compared to DDM. DDM can schedule code and data > migrations. Generally both require the Last-Modified date/time field to be > accurate. Overall, I'd personally recommend RRR|Chive. > > > HTH, > > --Phil > -- > *From:* Action Request System discussion list(ARSList) < > arslist@ARSLIST.ORG> on behalf of Nicosia, Ryan J. CTR USSOCOM HQ < > ryan.nicosia@socom.mil> > *Sent:* Wednesday, April 19, 2017 8:14 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: [Non-DoD Source] Re: need input about data migration after > Upgrade > I have to disagree. We used DDM with great success but it does require > admin freeze on all deletion activities of your production environment. > That said, there are ways to get around that as well but purging the form > in question on your target server and telling DDM to just pull everything > over. > > Once you get to the point where you are running DDM every few days, the > errors are easy to identify and clean up and you can re-run a specific > package as needed. > > Ryan > > -Original Message----- > From: Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG ] On Behalf Of Mohamed > Kamruzzaman > Sent: Wednesday, April 19, 2017 5:50 AM > To: arslist@ARSLIST.ORG > Subject: [Non-DoD Source] Re: need input about data migration after Upgrade > > Hi Amit, > > Agree with Vinod, you may want to look at alternate solution considering > you are looking at migrating and cleaning your data. You will want to > migrate over foundation, configuration and transactional data onto ITSM 9.x > . This is an ideal time to clean up data, remapping Prod cats and Op Cats > etc. and potentially archive some of the tickets that you no longer need. > > We use our Customer Move Tool (more info [CAUTION] > http://www.alderstone.com/cmt) for the migration from previous ITSM > versions to the latest, as we can migrate all modules data or a reduced set > (including transformation and cleaning of data), depending on your > requirements. In general we've been able to move entire data set within a > day ensuring a smooth migration. Please let me know if you would like to > talk about this in more detail or have any specific questions. > > Regards, > Mohamed > > Mohamed Kamruzzaman. Alderstone.com +962776723269 | mohamed.kamruzzaman@ > alderstone.com | Skype: mkamruzzaman | LinkedIn: Mohamed-Kamruzzaman > > > ___ > UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org > "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" > _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"
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
Misi, The last time I installed the tool, DDM had seperate folder structures with the instructions, mapping files, etc per version. When you run DDM, you select the "from-to" servers and the tool fetches the server versions - that's how it knows which mappings to use. Link to the docs: https://docs.bmc.com/docs/display/public/itsm81/Performing+the+data+migration I have used DDM strictly as a bulk data pump (which it was *not* designed for) and it is *aggravatingly* slow. Speed varies based on robustness of the environment and per record data sizes (ie attachments in worklogs, etc), but I was getting about 100 records every 8 to 16 or so seconds. Pretty awful. I was only moving less than 200k records, so it was tolerable. However, the benefit is that the tool handles cross version mappings and worked spot on accurately - even for custom forms & fields. Hope this helps! -JDHood ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
e the Last-Modified date/time field to be accurate. Overall, I'd personally recommend RRR|Chive. HTH, --Phil From: Action Request System discussion list(ARSList) on behalf of Nicosia, Ryan J. CTR USSOCOM HQ Sent: Wednesday, April 19, 2017 8:14 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: Re: [Non-DoD Source] Re: need input about data migration after Upgrade I have to disagree. We used DDM with great success but it does require admin freeze on all deletion activities of your production environment. That said, there are ways to get around that as well but purging the form in question on your target server and telling DDM to just pull everything over. Once you get to the point where you are running DDM every few days, the errors are easy to identify and clean up and you can re-run a specific package as needed. Ryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG)] On Behalf Of Mohamed Kamruzzaman Sent: Wednesday, April 19, 2017 5:50 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: [Non-DoD Source] Re: need input about data migration after Upgrade Hi Amit, Agree with Vinod, you may want to look at alternate solution considering you are looking at migrating and cleaning your data. You will want to migrate over foundation, configuration and transactional data onto ITSM 9.x . This is an ideal time to clean up data, remapping Prod cats and Op Cats etc. and potentially archive some of the tickets that you no longer need. We use our Customer Move Tool (more info [CAUTION] http://www.alderstone.com/cmt (http://www.alderstone.com/cmt)) for the migration from previous ITSM versions to the latest, as we can migrate all modules data or a reduced set (including transformation and cleaning of data), depending on your requirements. In general we've been able to move entire data set within a day ensuring a smooth migration. Please let me know if you would like to talk about this in more detail or have any specific questions. Regards, Mohamed Mohamed Kamruzzaman. Alderstone.com (http://Alderstone.com) +962776723269 | mohamed.kamruzza...@alderstone.com (mailto:mohamed.kamruzza...@alderstone.com) | Skype: mkamruzzaman | LinkedIn: Mohamed-Kamruzzaman ___ UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org (http://www.arslist.org) "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org (http://www.arslist.org) "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_ _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_ _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"
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 <http://www.softwaretoolhouse.com> Cheers, Ben Chernys Senior Software Architect Canada / Deutschland Mobile:+49 171 380 2329 GMT - 7 + [ DST ] Mobile +1 403 554 0887 Web: <http://www.softwaretoolhouse.com/> 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! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ 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 ** Hi, 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... https://rrr.se/cgi/index?pg=chive 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" mailto:%22amit%20b%22%20%3craccons...@gmail.com%3e> > 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 req
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
> Because of this it is easy to use to restore a system after, for example, >> testing. >> >> I have been playing with the idea of using the DDM mapping files in >> RRR|Chive, but have not come around to doing this. So you are pretty much >> on your own and need to do the mapping yourself. >> >> I am not 100% sure about this, but I think that DDM will not copy data on >> custom fields you have added yourself automatically. >> >> I have another tool I like to use when planning migrations to new >> application versions, and this is RRR|DefFieldDiff that will give you an >> excel sheet of all changed data fields. This makes it easy to find >> differences and plan your data massaging. >> >> 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 2:39 PM, "Murnane, Phil" > <%22Murnane,%20phil%22%20%3cphil.murn...@windward.com%3E>> wrote: >> >> We've used DDM and RRR|Chive successfully on various projects. Misi's >> tool is scriptable and very fast compared to DDM. DDM can schedule code and >> data migrations. Generally both require the Last-Modified date/time field >> to be accurate. Overall, I'd personally recommend RRR|Chive. >> >> >> HTH, >> >> --Phil >> -- >> *From:* Action Request System discussion list(ARSList) < >> arslist@ARSLIST.ORG> on behalf of Nicosia, Ryan J. CTR USSOCOM HQ < >> ryan.nicosia@socom.mil> >> *Sent:* Wednesday, April 19, 2017 8:14 AM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: [Non-DoD Source] Re: need input about data migration >> after Upgrade >> I have to disagree. We used DDM with great success but it does require >> admin freeze on all deletion activities of your production environment. >> That said, there are ways to get around that as well but purging the form >> in question on your target server and telling DDM to just pull everything >> over. >> >> Once you get to the point where you are running DDM every few days, the >> errors are easy to identify and clean up and you can re-run a specific >> package as needed. >> >> Ryan >> >> -Original Message- >> From: Action Request System discussion list(ARSList) [ >> mailto:arslist@ARSLIST.ORG ] On Behalf Of Mohamed >> Kamruzzaman >> Sent: Wednesday, April 19, 2017 5:50 AM >> To: arslist@ARSLIST.ORG >> Subject: [Non-DoD Source] Re: need input about data migration after >> Upgrade >> >> Hi Amit, >> >> Agree with Vinod, you may want to look at alternate solution considering >> you are looking at migrating and cleaning your data. You will want to >> migrate over foundation, configuration and transactional data onto ITSM 9.x >> . This is an ideal time to clean up data, remapping Prod cats and Op Cats >> etc. and potentially archive some of the tickets that you no longer need. >> >> We use our Customer Move Tool (more info [CAUTION] >> http://www.alderstone.com/cmt) for the migration from previous ITSM >> versions to the latest, as we can migrate all modules data or a reduced set >> (including transformation and cleaning of data), depending on your >> requirements. In general we've been able to move entire data set within a >> day ensuring a smooth migration. Please let me know if you would like to >> talk about this in more detail or have any specific questions. >> >> Regards, >> Mohamed >> >> Mohamed Kamruzzaman. Alderstone.com +962776723269 | >> mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: >> Mohamed-Kamruzzaman >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org >> "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" >> _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_ >> >> _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_ >> >> _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"
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
Hi, In other words it actually points to the .ARM file for mapping. So how is this structured, do you get a set of config/mapping files for each supported version transition? Best Regards - Misi, RRR AB, http://www.rrr.se (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 (http://rrr.se) April 24, 2017 10:01 AM, "Jarl Grøneng" wrote: ** Hi This is a DDM instruction file, and you can see that the field mapping using an import-tool format. PASS_QUALIFICATION Regards, Jarl 2017-04-20 14:48 GMT+02:00 Misi Mladoniczky : ** Hi, So RRR|Chive works in a similar way, where matching ids are the default, regardless if it is a custom field or not. Fields can then be mapped/skipped specifically. It sounds like a simple thing to generate rrrchive-config-files based on the mapping-files from DDM!? Any chanse of supplying me with a few DDM-config-files to allow me to check how much work it would take? Best Regards - Misi, RRR AB, http://www.rrr.se (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 (http://rrr.se) April 20, 2017 1:49 PM, "JD Hood" wrote: **As for custom fields, the in the 7.x version, the default DDM mapping was based on matching field IDs, unless a different mapping was specified. So as long as custom fields had the same field ID between the systems, the data would migrate correctly. So, with DDM migrating between two forms, it would map based on matching field IDs for all fields that were not mapped specifically. So if you looked at the mappings for the specifically mapped fields, it only listed the odd-ball fields that needed to be mapped because their ID's differed (presumably due to version changes). As long as custom fields had the same field ID between the systems (or if you manually edited the DDM mapping to include the custom fields if the ID's differed), the data would migrate correctly. Biggest issue I had with DDM is that it was slow, Slow, SLOOOW. Thanks, -JDHood On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani wrote: ** Thanks Misi, seems to be good and overcomes shortcomings of DDM. Vinod. On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky wrote: ** Hi, One big difference between DDM and RRR|Chive is that DDM just finds all records after the date/time you specify and transfer these records. RRR|Chive will pull all recordids and modify-dates from both system and then do transfer/delete as appropriate. No need to specify a date. Because of this it is easy to use to restore a system after, for example, testing. I have been playing with the idea of using the DDM mapping files in RRR|Chive, but have not come around to doing this. So you are pretty much on your own and need to do the mapping yourself. I am not 100% sure about this, but I think that DDM will not copy data on custom fields you have added yourself automatically. I have another tool I like to use when planning migrations to new application versions, and this is RRR|DefFieldDiff that will give you an excel sheet of all changed data fields. This makes it easy to find differences and plan your data massaging. Best Regards - Misi, RRR AB, http://www.rrr.se (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 (http://rrr.se) April 19, 2017 2:39 PM, "Murnane, Phil" wrote: We've used DDM and RRR|Chive successfully on various projects. Misi's tool is scriptable and very fast compared to DDM. DDM can schedule code and data migrations. Generally both require the Last-Modified date/time field to be accurate. Overall, I'd personally recommend RRR|Chive. HTH, --Phil From: Action Request System discussion list(ARSList) on behalf of Nicosia, Ryan J. CTR USSOCOM HQ Sent: Wednesday, April 19, 2017 8:14 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: Re: [Non-DoD Source] Re: need input about data migration after Upgrade I have to disagree. We used DDM with great success but it does require admin freeze on all deletion activities of your production environment. That said, there are ways to get around that as well but purging the for
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
Hi This is a DDM instruction file, and you can see that the field mapping using an import-tool format. PASS_QUALIFICATION Regards, Jarl 2017-04-20 14:48 GMT+02:00 Misi Mladoniczky : > ** > Hi, > > So RRR|Chive works in a similar way, where matching ids are the default, > regardless if it is a custom field or not. Fields can then be > mapped/skipped specifically. > > It sounds like a simple thing to generate rrrchive-config-files based on > the mapping-files from DDM!? Any chanse of supplying me with a few > DDM-config-files to allow me to check how much work it would take? > > 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 20, 2017 1:49 PM, "JD Hood" <%22jd%20hood%22%20%3chood...@gmail.com%3E>> wrote: > > ** > As for custom fields, the in the 7.x version, the default DDM mapping was > based on matching field IDs, unless a different mapping was specified. So > as long as custom fields had the same field ID between the systems, the > data would migrate correctly. > > So, with DDM migrating between two forms, it would map based on matching > field IDs for all fields that were not mapped specifically. So if you > looked at the mappings for the specifically mapped fields, it only listed > the odd-ball fields that needed to be mapped because their ID's differed > (presumably due to version changes). As long as custom fields had the same > field ID between the systems (or if you manually edited the DDM mapping to > include the custom fields if the ID's differed), the data would migrate > correctly. > Biggest issue I had with DDM is that it was slow, Slow, SLOOOW. > Thanks, > -JDHood > On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani > wrote: > > ** > Thanks Misi, seems to be good and overcomes shortcomings of DDM. > > Vinod. > > On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky wrote: > > ** > Hi, > > One big difference between DDM and RRR|Chive is that DDM just finds all > records after the date/time you specify and transfer these records. > > RRR|Chive will pull all recordids and modify-dates from both system and > then do transfer/delete as appropriate. No need to specify a date. > > Because of this it is easy to use to restore a system after, for example, > testing. > > I have been playing with the idea of using the DDM mapping files in > RRR|Chive, but have not come around to doing this. So you are pretty much > on your own and need to do the mapping yourself. > > I am not 100% sure about this, but I think that DDM will not copy data on > custom fields you have added yourself automatically. > > I have another tool I like to use when planning migrations to new > application versions, and this is RRR|DefFieldDiff that will give you an > excel sheet of all changed data fields. This makes it easy to find > differences and plan your data massaging. > > 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 2:39 PM, "Murnane, Phil" <%22Murnane,%20phil%22%20%3cphil.murn...@windward.com%3E>> wrote: > > We've used DDM and RRR|Chive successfully on various projects. Misi's tool > is scriptable and very fast compared to DDM. DDM can schedule code and data > migrations. Generally both require the Last-Modified date/time field to be > accurate. Overall, I'd personally recommend RRR|Chive. > > > HTH, > > --Phil > ------ > *From:* Action Request System discussion list(ARSList) < > arslist@ARSLIST.ORG> on behalf of Nicosia, Ryan J. CTR USSOCOM HQ < > ryan.nicosia@socom.mil> > *Sent:* Wednesday, April 19, 2017 8:14 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: [Non-DoD Source] Re: need input about data migration after > Upgrade > I have to disagree. We used DDM with great success but it does require > admin freeze on all deletion activities of your production environment. > That said, there are ways to get around that as well but purging the form > in question on your target server and telling DDM to just pull everythin
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
I currently lack access to a system - but I think DDM installs with Migrator? -JDHood On Thu, Apr 20, 2017 at 8:48 AM, Misi Mladoniczky wrote: > ** > Hi, > > So RRR|Chive works in a similar way, where matching ids are the default, > regardless if it is a custom field or not. Fields can then be > mapped/skipped specifically. > > It sounds like a simple thing to generate rrrchive-config-files based on > the mapping-files from DDM!? Any chanse of supplying me with a few > DDM-config-files to allow me to check how much work it would take? > > 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 20, 2017 1:49 PM, "JD Hood" <%22jd%20hood%22%20%3chood...@gmail.com%3E>> wrote: > > ** > As for custom fields, the in the 7.x version, the default DDM mapping was > based on matching field IDs, unless a different mapping was specified. So > as long as custom fields had the same field ID between the systems, the > data would migrate correctly. > > So, with DDM migrating between two forms, it would map based on matching > field IDs for all fields that were not mapped specifically. So if you > looked at the mappings for the specifically mapped fields, it only listed > the odd-ball fields that needed to be mapped because their ID's differed > (presumably due to version changes). As long as custom fields had the same > field ID between the systems (or if you manually edited the DDM mapping to > include the custom fields if the ID's differed), the data would migrate > correctly. > Biggest issue I had with DDM is that it was slow, Slow, SLOOOW. > Thanks, > -JDHood > On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani > wrote: > > ** > Thanks Misi, seems to be good and overcomes shortcomings of DDM. > > Vinod. > > On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky wrote: > > ** > Hi, > > One big difference between DDM and RRR|Chive is that DDM just finds all > records after the date/time you specify and transfer these records. > > RRR|Chive will pull all recordids and modify-dates from both system and > then do transfer/delete as appropriate. No need to specify a date. > > Because of this it is easy to use to restore a system after, for example, > testing. > > I have been playing with the idea of using the DDM mapping files in > RRR|Chive, but have not come around to doing this. So you are pretty much > on your own and need to do the mapping yourself. > > I am not 100% sure about this, but I think that DDM will not copy data on > custom fields you have added yourself automatically. > > I have another tool I like to use when planning migrations to new > application versions, and this is RRR|DefFieldDiff that will give you an > excel sheet of all changed data fields. This makes it easy to find > differences and plan your data massaging. > > 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 2:39 PM, "Murnane, Phil" <%22Murnane,%20phil%22%20%3cphil.murn...@windward.com%3E>> wrote: > > We've used DDM and RRR|Chive successfully on various projects. Misi's tool > is scriptable and very fast compared to DDM. DDM can schedule code and data > migrations. Generally both require the Last-Modified date/time field to be > accurate. Overall, I'd personally recommend RRR|Chive. > > > HTH, > > --Phil > ------ > *From:* Action Request System discussion list(ARSList) < > arslist@ARSLIST.ORG> on behalf of Nicosia, Ryan J. CTR USSOCOM HQ < > ryan.nicosia@socom.mil> > *Sent:* Wednesday, April 19, 2017 8:14 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: [Non-DoD Source] Re: need input about data migration after > Upgrade > I have to disagree. We used DDM with great success but it does require > admin freeze on all deletion activities of your production environment. > That said, there are ways to get around that as well but purging the form > in question on your target server and telling DDM to just pull everything > over. > > Once you get to the point where you are running DDM every
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
Hi, So RRR|Chive works in a similar way, where matching ids are the default, regardless if it is a custom field or not. Fields can then be mapped/skipped specifically. It sounds like a simple thing to generate rrrchive-config-files based on the mapping-files from DDM!? Any chanse of supplying me with a few DDM-config-files to allow me to check how much work it would take? Best Regards - Misi, RRR AB, http://www.rrr.se (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 (http://rrr.se) April 20, 2017 1:49 PM, "JD Hood" wrote: **As for custom fields, the in the 7.x version, the default DDM mapping was based on matching field IDs, unless a different mapping was specified. So as long as custom fields had the same field ID between the systems, the data would migrate correctly. So, with DDM migrating between two forms, it would map based on matching field IDs for all fields that were not mapped specifically. So if you looked at the mappings for the specifically mapped fields, it only listed the odd-ball fields that needed to be mapped because their ID's differed (presumably due to version changes). As long as custom fields had the same field ID between the systems (or if you manually edited the DDM mapping to include the custom fields if the ID's differed), the data would migrate correctly. Biggest issue I had with DDM is that it was slow, Slow, SLOOOW. Thanks, -JDHood On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani wrote: ** Thanks Misi, seems to be good and overcomes shortcomings of DDM. Vinod. On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky wrote: ** Hi, One big difference between DDM and RRR|Chive is that DDM just finds all records after the date/time you specify and transfer these records. RRR|Chive will pull all recordids and modify-dates from both system and then do transfer/delete as appropriate. No need to specify a date. Because of this it is easy to use to restore a system after, for example, testing. I have been playing with the idea of using the DDM mapping files in RRR|Chive, but have not come around to doing this. So you are pretty much on your own and need to do the mapping yourself. I am not 100% sure about this, but I think that DDM will not copy data on custom fields you have added yourself automatically. I have another tool I like to use when planning migrations to new application versions, and this is RRR|DefFieldDiff that will give you an excel sheet of all changed data fields. This makes it easy to find differences and plan your data massaging. Best Regards - Misi, RRR AB, http://www.rrr.se (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 (http://rrr.se) April 19, 2017 2:39 PM, "Murnane, Phil" wrote: We've used DDM and RRR|Chive successfully on various projects. Misi's tool is scriptable and very fast compared to DDM. DDM can schedule code and data migrations. Generally both require the Last-Modified date/time field to be accurate. Overall, I'd personally recommend RRR|Chive. HTH, --Phil From: Action Request System discussion list(ARSList) on behalf of Nicosia, Ryan J. CTR USSOCOM HQ Sent: Wednesday, April 19, 2017 8:14 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: Re: [Non-DoD Source] Re: need input about data migration after Upgrade I have to disagree. We used DDM with great success but it does require admin freeze on all deletion activities of your production environment. That said, there are ways to get around that as well but purging the form in question on your target server and telling DDM to just pull everything over. Once you get to the point where you are running DDM every few days, the errors are easy to identify and clean up and you can re-run a specific package as needed. Ryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG)] On Behalf Of Mohamed Kamruzzaman Sent: Wednesday, April 19, 2017 5:50 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: [Non-DoD Source] Re: need input about data migration after Upgrade Hi Amit, Agree with Vinod, you may want to look at alternate solution considering you are looking at migrating and cleaning your data. You will want to migrate over foundation, configuration and transactional data onto ITSM
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
As for custom fields, the in the 7.x version, the default DDM mapping was based on matching field IDs, unless a different mapping was specified. So as long as custom fields had the same field ID between the systems, the data would migrate correctly. So, with DDM migrating between two forms, it would map based on matching field IDs for all fields that were not mapped specifically. So if you looked at the mappings for the specifically mapped fields, it only listed the odd-ball fields that needed to be mapped because their ID's differed (presumably due to version changes). As long as custom fields had the same field ID between the systems (or if you manually edited the DDM mapping to include the custom fields if the ID's differed), the data would migrate correctly. Biggest issue I had with DDM is that it was slow, Slow, SLOOOW. Thanks, -JDHood On Thu, Apr 20, 2017 at 6:19 AM, Vinod Gaidhani wrote: > ** > Thanks Misi, seems to be good and overcomes shortcomings of DDM. > > Vinod. > > On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky wrote: > > ** > Hi, > > One big difference between DDM and RRR|Chive is that DDM just finds all > records after the date/time you specify and transfer these records. > > RRR|Chive will pull all recordids and modify-dates from both system and > then do transfer/delete as appropriate. No need to specify a date. > > Because of this it is easy to use to restore a system after, for example, > testing. > > I have been playing with the idea of using the DDM mapping files in > RRR|Chive, but have not come around to doing this. So you are pretty much > on your own and need to do the mapping yourself. > > I am not 100% sure about this, but I think that DDM will not copy data on > custom fields you have added yourself automatically. > > I have another tool I like to use when planning migrations to new > application versions, and this is RRR|DefFieldDiff that will give you an > excel sheet of all changed data fields. This makes it easy to find > differences and plan your data massaging. > > 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 2:39 PM, "Murnane, Phil" <%22Murnane,%20phil%22%20%3cphil.murn...@windward.com%3E>> wrote: > > We've used DDM and RRR|Chive successfully on various projects. Misi's tool > is scriptable and very fast compared to DDM. DDM can schedule code and data > migrations. Generally both require the Last-Modified date/time field to be > accurate. Overall, I'd personally recommend RRR|Chive. > > > HTH, > > --Phil > -- > *From:* Action Request System discussion list(ARSList) < > arslist@ARSLIST.ORG> on behalf of Nicosia, Ryan J. CTR USSOCOM HQ < > ryan.nicosia@socom.mil> > *Sent:* Wednesday, April 19, 2017 8:14 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: [Non-DoD Source] Re: need input about data migration after > Upgrade > I have to disagree. We used DDM with great success but it does require > admin freeze on all deletion activities of your production environment. > That said, there are ways to get around that as well but purging the form > in question on your target server and telling DDM to just pull everything > over. > > Once you get to the point where you are running DDM every few days, the > errors are easy to identify and clean up and you can re-run a specific > package as needed. > > Ryan > > -----Original Message- > From: Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG ] On Behalf Of Mohamed > Kamruzzaman > Sent: Wednesday, April 19, 2017 5:50 AM > To: arslist@ARSLIST.ORG > Subject: [Non-DoD Source] Re: need input about data migration after Upgrade > > Hi Amit, > > Agree with Vinod, you may want to look at alternate solution considering > you are looking at migrating and cleaning your data. You will want to > migrate over foundation, configuration and transactional data onto ITSM 9.x > . This is an ideal time to clean up data, remapping Prod cats and Op Cats > etc. and potentially archive some of the tickets that you no longer need. > > We use our Customer Move Tool (more info [CAUTION] > http://www.alderstone.com/cmt) for the migration from previous ITSM > versions to the latest, as we can migrate all modules data or a reduced set > (including transformation and cleaning of data), depending on your > requirements. In general
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
Thanks Misi, seems to be good and overcomes shortcomings of DDM. Vinod. > On 20-Apr-2017, at 2:30 PM, Misi Mladoniczky wrote: > > ** > Hi, > > One big difference between DDM and RRR|Chive is that DDM just finds all > records after the date/time you specify and transfer these records. > > RRR|Chive will pull all recordids and modify-dates from both system and then > do transfer/delete as appropriate. No need to specify a date. > > Because of this it is easy to use to restore a system after, for example, > testing. > > I have been playing with the idea of using the DDM mapping files in > RRR|Chive, but have not come around to doing this. So you are pretty much on > your own and need to do the mapping yourself. > > I am not 100% sure about this, but I think that DDM will not copy data on > custom fields you have added yourself automatically. > > I have another tool I like to use when planning migrations to new application > versions, and this is RRR|DefFieldDiff that will give you an excel sheet of > all changed data fields. This makes it easy to find differences and plan your > data massaging. > > 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 2:39 PM, "Murnane, Phil" wrote: > We've used DDM and RRR|Chive successfully on various projects. Misi's tool is > scriptable and very fast compared to DDM. DDM can schedule code and data > migrations. Generally both require the Last-Modified date/time field to be > accurate. Overall, I'd personally recommend RRR|Chive. > > > HTH, > > --Phil > > From: Action Request System discussion list(ARSList) on > behalf of Nicosia, Ryan J. CTR USSOCOM HQ > Sent: Wednesday, April 19, 2017 8:14 AM > To: arslist@ARSLIST.ORG > Subject: Re: [Non-DoD Source] Re: need input about data migration after > Upgrade > I have to disagree. We used DDM with great success but it does require admin > freeze on all deletion activities of your production environment. That said, > there are ways to get around that as well but purging the form in question on > your target server and telling DDM to just pull everything over. > > Once you get to the point where you are running DDM every few days, the > errors are easy to identify and clean up and you can re-run a specific > package as needed. > > Ryan > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Mohamed Kamruzzaman > Sent: Wednesday, April 19, 2017 5:50 AM > To: arslist@ARSLIST.ORG > Subject: [Non-DoD Source] Re: need input about data migration after Upgrade > > Hi Amit, > > Agree with Vinod, you may want to look at alternate solution considering you > are looking at migrating and cleaning your data. You will want to migrate > over foundation, configuration and transactional data onto ITSM 9.x . This is > an ideal time to clean up data, remapping Prod cats and Op Cats etc. and > potentially archive some of the tickets that you no longer need. > > We use our Customer Move Tool (more info [CAUTION] > http://www.alderstone.com/cmt) for the migration from previous ITSM versions > to the latest, as we can migrate all modules data or a reduced set (including > transformation and cleaning of data), depending on your requirements. In > general we've been able to move entire data set within a day ensuring a > smooth migration. Please let me know if you would like to talk about this in > more detail or have any specific questions. > > Regards, > Mohamed > > Mohamed Kamruzzaman. Alderstone.com +962776723269 | > mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: > Mohamed-Kamruzzaman > > ___ > UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org "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" > _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"
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
Hi, One big difference between DDM and RRR|Chive is that DDM just finds all records after the date/time you specify and transfer these records. RRR|Chive will pull all recordids and modify-dates from both system and then do transfer/delete as appropriate. No need to specify a date. Because of this it is easy to use to restore a system after, for example, testing. I have been playing with the idea of using the DDM mapping files in RRR|Chive, but have not come around to doing this. So you are pretty much on your own and need to do the mapping yourself. I am not 100% sure about this, but I think that DDM will not copy data on custom fields you have added yourself automatically. I have another tool I like to use when planning migrations to new application versions, and this is RRR|DefFieldDiff that will give you an excel sheet of all changed data fields. This makes it easy to find differences and plan your data massaging. Best Regards - Misi, RRR AB, http://www.rrr.se (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 (http://rrr.se) April 19, 2017 2:39 PM, "Murnane, Phil" wrote: We've used DDM and RRR|Chive successfully on various projects. Misi's tool is scriptable and very fast compared to DDM. DDM can schedule code and data migrations. Generally both require the Last-Modified date/time field to be accurate. Overall, I'd personally recommend RRR|Chive. HTH, --Phil From: Action Request System discussion list(ARSList) on behalf of Nicosia, Ryan J. CTR USSOCOM HQ Sent: Wednesday, April 19, 2017 8:14 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: Re: [Non-DoD Source] Re: need input about data migration after Upgrade I have to disagree. We used DDM with great success but it does require admin freeze on all deletion activities of your production environment. That said, there are ways to get around that as well but purging the form in question on your target server and telling DDM to just pull everything over. Once you get to the point where you are running DDM every few days, the errors are easy to identify and clean up and you can re-run a specific package as needed. Ryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG)] On Behalf Of Mohamed Kamruzzaman Sent: Wednesday, April 19, 2017 5:50 AM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: [Non-DoD Source] Re: need input about data migration after Upgrade Hi Amit, Agree with Vinod, you may want to look at alternate solution considering you are looking at migrating and cleaning your data. You will want to migrate over foundation, configuration and transactional data onto ITSM 9.x . This is an ideal time to clean up data, remapping Prod cats and Op Cats etc. and potentially archive some of the tickets that you no longer need. We use our Customer Move Tool (more info [CAUTION] http://www.alderstone.com/cmt (http://www.alderstone.com/cmt)) for the migration from previous ITSM versions to the latest, as we can migrate all modules data or a reduced set (including transformation and cleaning of data), depending on your requirements. In general we've been able to move entire data set within a day ensuring a smooth migration. Please let me know if you would like to talk about this in more detail or have any specific questions. Regards, Mohamed Mohamed Kamruzzaman. Alderstone.com +962776723269 | mohamed.kamruzza...@alderstone.com (mailto:mohamed.kamruzza...@alderstone.com) | Skype: mkamruzzaman | LinkedIn: Mohamed-Kamruzzaman ___ UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org (http://www.arslist.org) "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org (http://www.arslist.org) "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"
Re: need input about data migration after Upgrade
Hi Amit, You can use ITSM Bridge (www.itsmbridge.com) to perform a delta data migration of records from any Remedy application to ITSM 91. It uses a configurable Remedy-like query to determine which records to select for migration. There is also a delete configuration option to allow optional deletion of target records where there is no matching record on the source server. Standard templates are available for Incident, problem, change etc. , full reporting on all migrations and all presented in a friendly Java-based user interface. Please let me know if you need any further information. Kind Regards Mark Herring Co-Founder www.itsmbridge.com > On 19 Apr 2017, at 23:00, arslist automatic digest system > wrote: > > need input about data migration after Upgrade ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
I would use each in a different situation. RRRChive: I would use when I have two identical systems that I'm migrating data between (prod->dev for example) DDM: Useful for doing the migration from version X to version X+1it contains all of the mappings to move data between versions when doing staged upgrades. On Wed, Apr 19, 2017 at 6:38 AM, Murnane, Phil wrote: > ** > > We've used DDM and RRR|Chive successfully on various projects. Misi's > tool is scriptable and very fast compared to DDM. DDM can schedule code > and data migrations. Generally both require the Last-Modified date/time > field to be accurate. Overall, I'd personally recommend RRR|Chive. > > > HTH, > > --Phil > -- > *From:* Action Request System discussion list(ARSList) < > arslist@ARSLIST.ORG> on behalf of Nicosia, Ryan J. CTR USSOCOM HQ < > ryan.nicosia@socom.mil> > *Sent:* Wednesday, April 19, 2017 8:14 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: [Non-DoD Source] Re: need input about data migration after > Upgrade > > I have to disagree. We used DDM with great success but it does require > admin freeze on all deletion activities of your production environment. > That said, there are ways to get around that as well but purging the form > in question on your target server and telling DDM to just pull everything > over. > > Once you get to the point where you are running DDM every few days, the > errors are easy to identify and clean up and you can re-run a specific > package as needed. > > Ryan > > -Original Message- > From: Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG ] On Behalf Of Mohamed > Kamruzzaman > Sent: Wednesday, April 19, 2017 5:50 AM > To: arslist@ARSLIST.ORG > Subject: [Non-DoD Source] Re: need input about data migration after Upgrade > > Hi Amit, > > Agree with Vinod, you may want to look at alternate solution considering > you are looking at migrating and cleaning your data. You will want to > migrate over foundation, configuration and transactional data onto ITSM 9.x > . This is an ideal time to clean up data, remapping Prod cats and Op Cats > etc. and potentially archive some of the tickets that you no longer need. > > We use our Customer Move Tool (more info [CAUTION] > http://www.alderstone.com/cmt) for the migration from previous ITSM > versions to the latest, as we can migrate all modules data or a reduced set > (including transformation and cleaning of data), depending on your > requirements. In general we've been able to move entire data set within a > day ensuring a smooth migration. Please let me know if you would like to > talk about this in more detail or have any specific questions. > > Regards, > Mohamed > > Mohamed Kamruzzaman. Alderstone.com +962776723269 <+962%207%207672%203269> > | mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: > Mohamed-Kamruzzaman > > > ___ > UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org > "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" > _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"
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
We've used DDM and RRR|Chive successfully on various projects. Misi's tool is scriptable and very fast compared to DDM. DDM can schedule code and data migrations. Generally both require the Last-Modified date/time field to be accurate. Overall, I'd personally recommend RRR|Chive. HTH, --Phil From: Action Request System discussion list(ARSList) on behalf of Nicosia, Ryan J. CTR USSOCOM HQ Sent: Wednesday, April 19, 2017 8:14 AM To: arslist@ARSLIST.ORG Subject: Re: [Non-DoD Source] Re: need input about data migration after Upgrade I have to disagree. We used DDM with great success but it does require admin freeze on all deletion activities of your production environment. That said, there are ways to get around that as well but purging the form in question on your target server and telling DDM to just pull everything over. Once you get to the point where you are running DDM every few days, the errors are easy to identify and clean up and you can re-run a specific package as needed. Ryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mohamed Kamruzzaman Sent: Wednesday, April 19, 2017 5:50 AM To: arslist@ARSLIST.ORG Subject: [Non-DoD Source] Re: need input about data migration after Upgrade Hi Amit, Agree with Vinod, you may want to look at alternate solution considering you are looking at migrating and cleaning your data. You will want to migrate over foundation, configuration and transactional data onto ITSM 9.x . This is an ideal time to clean up data, remapping Prod cats and Op Cats etc. and potentially archive some of the tickets that you no longer need. We use our Customer Move Tool (more info [CAUTION] http://www.alderstone.com/cmt) for the migration from previous ITSM versions to the latest, as we can migrate all modules data or a reduced set (including transformation and cleaning of data), depending on your requirements. In general we've been able to move entire data set within a day ensuring a smooth migration. Please let me know if you would like to talk about this in more detail or have any specific questions. Regards, Mohamed Mohamed Kamruzzaman. Alderstone.com +962776723269 | mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: Mohamed-Kamruzzaman ___ UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "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"
Re: [Non-DoD Source] Re: need input about data migration after Upgrade
I have to disagree. We used DDM with great success but it does require admin freeze on all deletion activities of your production environment. That said, there are ways to get around that as well but purging the form in question on your target server and telling DDM to just pull everything over. Once you get to the point where you are running DDM every few days, the errors are easy to identify and clean up and you can re-run a specific package as needed. Ryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mohamed Kamruzzaman Sent: Wednesday, April 19, 2017 5:50 AM To: arslist@ARSLIST.ORG Subject: [Non-DoD Source] Re: need input about data migration after Upgrade Hi Amit, Agree with Vinod, you may want to look at alternate solution considering you are looking at migrating and cleaning your data. You will want to migrate over foundation, configuration and transactional data onto ITSM 9.x . This is an ideal time to clean up data, remapping Prod cats and Op Cats etc. and potentially archive some of the tickets that you no longer need. We use our Customer Move Tool (more info [CAUTION] http://www.alderstone.com/cmt) for the migration from previous ITSM versions to the latest, as we can migrate all modules data or a reduced set (including transformation and cleaning of data), depending on your requirements. In general we've been able to move entire data set within a day ensuring a smooth migration. Please let me know if you would like to talk about this in more detail or have any specific questions. Regards, Mohamed Mohamed Kamruzzaman. Alderstone.com +962776723269 | mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: Mohamed-Kamruzzaman ___ UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org "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"
Re: need input about data migration after Upgrade
Hi, 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... https://rrr.se/cgi/index?pg=chive (https://rrr.se/cgi/index?pg=chive) You might also consider talking to Ben Chernys at http://www.softwaretoolhouse.com/ (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 (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 (http://rrr.se) April 19, 2017 9:11 AM, "Amit B" 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 ? Reagrds, Amit B _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"
Re: need input about data migration after Upgrade
Hi Amit, Agree with Vinod, you may want to look at alternate solution considering you are looking at migrating and cleaning your data. You will want to migrate over foundation, configuration and transactional data onto ITSM 9.x . This is an ideal time to clean up data, remapping Prod cats and Op Cats etc. and potentially archive some of the tickets that you no longer need. We use our Customer Move Tool (more info http://www.alderstone.com/cmt) for the migration from previous ITSM versions to the latest, as we can migrate all modules data or a reduced set (including transformation and cleaning of data), depending on your requirements. In general we've been able to move entire data set within a day ensuring a smooth migration. Please let me know if you would like to talk about this in more detail or have any specific questions. Regards, Mohamed Mohamed Kamruzzaman. Alderstone.com +962776723269 | mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: Mohamed-Kamruzzaman ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: need input about data migration after Upgrade
Hi Amit, DDM is not capable of handling any data removal activities for e.g. If you remove any permission from people form, it will reappear after applying DDM. It is worst tool I have used ever honestly, considering the lack of information provided in docs. Use it very carefully. Sent from my iPhone > On 19-Apr-2017, at 12:37 PM, Amit B 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 ? > > Reagrds, > > Amit B > _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"