Hi Lyndsay
Apologies for the length of the post, it isn’t a simple question to answer. I have previously used both DDM and RRRchive. While RRRchive has some great improvements in terms of handling the deletion of data and configurability, the main issue you're likely to face is performance. The Remedy API is great at a number of things, but bulk data migration is not among them. Using RRRchive, it previously took us over thirty days to accomplish a full data migration from a full copy of a Production system. After that migration, we then had to perform multiple delta migration runs leading up to go-live. The inherent limitation of the Remedy API has been recognised by BMC, and for the DDM product, some Forms like Audit and Worklogs are now migrated at the database level. Your approach of creating a new environment, rather than upgrading-in-place is one with a lot of advantages; with a fresh install you can be confident that all ITSM modules have been installed cleanly and you can fully test the environment prior to the cutover - I really prefer this approach. Unfortunately the challenges of moving all the data has put some companies off. In response to these challenges, we, at Alderstone Consulting, have spent the last two years developing a powerful data migration tool specifically for the BMC ITSM platform. It’s really good at migrating data for the kind of parallel environment upgrade you're performing, as well as other data migration tasks. Our website at www.alderstone.com/cmt has a lot more information. In summary, our tool has a number of advantages over other tools currently available; 1. Moves data at the database level - we are typically able to move an entire ITSM application within a single day, rather than several weeks. The final delta migration for the Production cutover is less than an hour. 2. Automated discovery and analysis - CMT will discover a Remedy application including customizations and map the data. Any discrepancies like mismatched field lengths, missing enums or missing fields are identified and presented in the CMT Workbench web UI. This is a distinct advantage over other tools, which require you to mess about with XML files and will not automatically identify differences or pick up customisations. For a lightly customised system we would typically be ready to move data within a couple of days - which believe me compares very favourably to the effort expended in previous upgrade projects I've been involved in! 3. Relationship Aware – while other tools migrate on a simple form-by-form basis, CMT builds a data model of your Remedy application which it uses to migrate data.. This opens up a number of capabilities such as being able to migrate individual ITSM companies between Remedy systems, consolidating multiple Remedy systems into a single multi-tenancy system, performing archiving of data during data migration, etc. 4. Flexible and Powerful Mapping and Transformation– using the CMT web user interface you have full control over the way data is migrated and can transform and map data to handle a range of scenarios, including populating new fields with defaults, transforming Product Catalog data, selectively mapping data to new Forms, fields or entities. In fact, CMT would support all of the Remedy-to-Remedy cases Ben Cherny’s identified. Finally CMT handles data deletions, has outstanding exception management (no more searching through log files) and very good operational capabilities Please let me know if you'd like to discuss this further ( sean.harries@alderstone,com) or you could sign up for one of our webinars at http://alderstone.com/cmt-events/ We will also be at BMC Engage next week, please look for us on the KTSL stand at #509. Cheers Sean *Sean Harries* Alderstone Consulting Ltd Revolutionise your management of BMC Remedy ITSM Services with CMT <http://alderstone.com/cmt/> Mobile: +44 (0)7976 558048 Skype: seanharries MSN: seanharr...@alderstone.com <sean.harr...@alderstone.com> e-mail: sean.harr...@alderstone.com Linkedin: http://www.linkedin.com/in/seanharries On 7 October 2014 15:42, Ben Chernys <ben.cher...@softwaretoolhouse.com> wrote: > ** > > There is also Meta-Update <http://www.softwaretoolhouse.com/> and > specifically the ITSM 7.1 Migration Package > <http://www.softwaretoolhouse.com/product/PkgMigItsm/index.html> of > scripts which allows you to change your companies, organization, people, > support structure, product catalogue – and even Changes of type Release > into Releases – along the way. > > > > No it is not free but the costs are small compared to the efforts saved. > > > > Contact me off list for more details or trials. > > > > Cheers > > > > Ben Chernys > Senior Software Architect > [image: logoSthInc-sm] > > Canada / Deutschland > Mobile: +49 171 380 2329 GMT + 1 + [ DST ] > Email: > *Ben.Chernys_AT_softwaretoolhouse.com > <Ben.Chernys_AT_softwaretoolhouse.com>*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 the tree of data and > forms that it is it is. > > > > Pre ITSM 7.6.04? Clarify? Roll your own? No problem! > > You can keep your valuable data! > > > http://www.softwaretoolhouse.com/ > > > > > > > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Lyndsay Reese > *Sent:* October-07-14 15:51 > *To:* arslist@ARSLIST.ORG > *Subject:* RRR|Chive vs. DDM > > > > ** > > Hello arslisters, > > I am in need of a good data migration tool to get all of our current > ARS/ITSM 7.5 production data over to our new ARS/ITSM 8.1.01 fresh install > server, with moderate customizations (we were not interested in copying our > full prod db to the new server and then upgrading it, as it has had its own > issues in the past with prior installs and upgrades and customizations). > Therefore, the servers are not identical. The new server is built, > customized, and UAT tested. We do have a development server where we took a > db copy of prod, upgraded it to 8.1.01 (to match versions with the new > server) and now we need to migrate the data. I've never used RRR|Chive or > DDM. Is one better than the other for this type of migration? > > > > Thanks in advance for any thoughts/opinions/suggestions. > > > > Lyndsay > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2013.0.3485 / Virus Database: 4031/8340 - Release Date: 10/07/14 > _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"