Hi,
I will only touch the specific question about DDM vs RRR|Chive.
DDM was not really designed to copy the amount of data in a complete system.
RRR|Chive has better delta migration functionality, and will delete/restore
tickets as appropriate.
Copying all records of a big system takes days or weeks through the API. But
the final Delta transfer using RRR|Chive should not take more than a few
hours.
Using RRR|Chive you need to understand which data you want to skip.
I just had a client going from 7.6 to 8.1 doing this. They were quite big. The
downtime was 3 hours for the cut-over.
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.
> Hi Lyndsay,
>
> A bit over a year ago I architected & implemented the data migration for my
> client at the time, which involved an upgrade from 7.1 to 8.1, and a
> migration of the data from Oracle to SQL Server. Like you, we only wanted
> to migrate a subset of the data and leave a whole bunch of garbage behind.
>
> This custom solution had a Remedy based control and configuration
> application along with a .NET executable. The control & config app was used
> pretty simply to describe which forms we were interested in migrating along
> with connection and authentication info. The exe then used this info to
> affect the data transfer.
>
> Unlike other Remedy based data migration tools out there, this solution did
> NOT transfer the data through the Remedy servers, but instead used the ARS
> data dictionary info about each of the required forms to dynamically
> construct SQL statements which affected the data transfers through a
> database link between the legacy and new DBs (e.g. SELECT INTO and UPDATE
> FROM type statements). It was very fast.
>
> If you don't find another solution and are interested, I'd be happy to
> provide more details about how this thing worked.
>
> -charlie
>
> On Tue, Oct 7, 2014 at 7:42 AM, Ben Chernys <
> [email protected]> 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:
>> [email protected]] *On Behalf Of *Lyndsay Reese
>> *Sent:* October-07-14 15:51
>> *To:* [email protected]
>> *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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"