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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
