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"
