There are a lot of transformations needed as you will note that ITSM 8.1 has many new fields and forms over 7.1. Some fields that had null values now are required to have correct values due to workflow changes. Some enums have changed. Also, due to errors in the 7.1 workflow, some data is actually invalid in 8.1. Of-course, none of the data changes are documented J
To compare field and forms, please see our Freebies <http://www.softwaretoolhouse.com/freebies/index.html> for ITSM 7.6.01, 8.0, 8.1. Download the source CSV files. Then, you can simply run diffs on the different versions. If you wanted to generate similar CSVs for your system(s), a Meta-Update trial license <http://www.softwaretoolhouse.com/product/SthMupd/mupd_liveinstall.html> (free) would be all that you needed. We have a package of scripts that can migrate data AND allow for Company, Support Group, Operational & Product Catalogue Merges, Deletions and Changes. It can also migrate Changes of Type "Release" to Releases. This fully automated system is available as an add-on package with support and requires Meta-Update licensing. Due to the complex nature of the transformations required, this package is not available with our trial version. For further information on this package, please contact me off-list. For further information on Meta-Update, please review www.softwaretoolhouse.com Cheers, Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com 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 out Freebies Section for a ITSM 7.6.04 and 8.0.0 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. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Charlie Lotridge Sent: January-13-14 16:38 To: [email protected] Subject: Re: Delta Data Migration for initial data migration. ** Hi Ken, For my last client (eBay), I orchestrated an upgrade from 7.1 to 8.1 (data only, not UI) of a purely custom application (no ITSM). The upgrade was complicated by the fact that we decided to move from Oracle back-end to SQL Server, which of course made doing either a direct in-place upgrade, or using a db copy, impossible. So, I designed and wrote a custom API program that analyzed the forms containing data to be transferred, then dynamically constructed SQL that it then ran on the target DB which pulled the bulk of the data directly from DB to DB through a database link (all non-LOB data - the LOB data had to be handled a bit differently). We then just exported/imported the form & workflow definitions to the new server, then ran this program to handle the data. This solution did not perform any data transformations between the systems and in fact was designed assumed none were needed. I don't know what kind of data transformations need to take place during the upgrade path from 7.6 to 8.1. of ITSM, but if they're significant, this type of solution may not work for you. But if not, and if you need a solution like this and have the resources to implemented it, I'd be happy to share more details about the strategy. Let me know. Thanks, Charlie On Mon, Jan 13, 2014 at 7:09 AM, Cecil, Ken <[email protected]> wrote: Misi, Will RRR|Chive work when moving from ITSM 7.6 to 8.1? Do I have to define mapping to get from one version of the forms to the new version? Define mappings for all of the ITSM forms? How do I determine which forms? Ken. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Monday, January 13, 2014 9:44 AM To: [email protected] Subject: Re: Delta Data Migration for initial data migration. Hi, While not solving the problem LJ is talking about, DDM is not really designed for such big data transfers. Try RRR|Chive instead. 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. > Ken, > Doing so will wipe out some critical information on your destination > environment like shr properties records, cmdb class information, etc, > I don't recommend running it in that situation. > On Jan 12, 2014 10:20 PM, "Cecil, Ken" <[email protected]> wrote: > >> ** >> >> Anybody tried using the Delta Data Migration utility for doing an >> initial data migration from one system to a new build that is not a >> db copy nor an upgraded system? >> >> >> >> Example, Production 7.6 system to 8.1 system (clean db) >> >> >> >> It would seems like it should be possible in theory if you specify >> something early like (1/1/1970 as the start date). >> >> >> >> >> >> Ken. >> >> >> >> >> ------------------------------ >> >> >> --------------------------------------------------------------------- >> ------------------------------------------------------- >> >> >> Confidentiality Requirement: This communication, including any >> attachment(s), may contain confidential information and is for the >> sole use of the intended recipient(s). If you are not the intended >> recipient, you are hereby notified that you have received this >> communication in error and any unauthorized review, use, disclosure, >> dissemination, distribution or copying of it or its contents is >> strictly prohibited. If you have received this communication in >> error, please notify the sender immediately by telephone or e-mail >> and destroy all copies of this communication and any attachments. >> _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" ____________________________________________________________________________ ___ 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_ No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.3462 / Virus Database: 3658/6997 - Release Date: 01/12/14 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<image003.jpg>>
smime.p7s
Description: S/MIME cryptographic signature
