SYNCTOTARGET is appropriate ONLY on forms where there is no 7.6 data that is different from what is on 7.0, and that will not be the case wherever they switched the records from My Company to Calbro. Pure transaction forms like HPD:Help Desk and HPD:WorkLog will be fine (plus or minus any custom fields or changes to fields between 7.0 and 7.6). For example, you can't/shouldn't use it for these:
Group (many diffs between 7.6.03 new vs upgraded systems) COM:Company COM:Company Alias CTM:Region ...but I'm pretty sure I can/should for these: CTM:People Organization (part of Location) CTM:Support Group CTM:Support Group Alias CTM:SYS-Access Permission Grps ...because the Calbro records overlap my existing data on the same IDs and actually NEED to be overwritten. Misi, correct me if I am wrong, but... SYNCTOTARGET will compare both tables, delete all records on the target that are not on the source, then copy everything from the source to the target. It acts like a SYNCDELETED followed by a COPY. COPY will copy everything from the source to the target, but in our experience will overwrite some records in the process. There will be tables that COPY fits better than SYNC*. I had this mapped out very well for updating an upgraded server, but not for a 100% migration; that is what I am doing now, and it is more complicated. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Tuesday, January 11, 2011 12:28 PM To: arslist@ARSLIST.ORG Subject: Re: RRRchive for upgrade I'm looking as doing this as part of an upgrade from 7.0 to 7.6 ITSM. Would a full SYNCTOTARGET work properly in this case? Anne Ramey Remedy System Administrator State of North Carolina Office of Information Technology Services (ITS) Service Delivery Division ITSM & ITAM Services Office (919) 754-6521 Home Office (919) 842-5420 ITS Service Desk : (919) 754-6000 or (800) 722-3946 anne.ra...@nc.gov http://its.state.nc.us RHCE, ITIL Foundation *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Tuesday, January 11, 2011 2:17 AM To: arslist@ARSLIST.ORG Subject: Re: RRRchive for upgrade Hi, If you do a full SYNCTOTARGET between the same ITSM-version, you should not break anything. If you just sync a couple of forms, or copy between different versions of ITSM, you may need to keep track of underlying relationships. It can get complicated! Unfortunately, there seems to be no definite repository that tells us exactly how to handle these relationships... If you do manual copy of data over ARX-files, you have exactly the same problem. With a little help from the list, and with some analysis/testing of your own, you should be able to do it. Others have, and I know that some of them should be willing to share their experience. If you can have your new server in place for a period of time, you can do a lot of testing without affecting your production system. When you have fine tuned your rrrchive-configs to perfection, do a last SYNCTOTARGET and switch production server. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * 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. > Misi, > > What about Don's assertion that this will break the People & Location > Records? That would be a real concern for us. > > Anne Ramey > *********************************** > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and may be disclosed to third parties only by > an authorized State Official. > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky > Sent: Saturday, January 08, 2011 6:54 AM > To: arslist@ARSLIST.ORG > Subject: Re: RRRchive for upgrade > > Hi, > > The multipleforms=* will definitely work in Regular forms only, so that is > not a problem. > > When I use that parameter, I typically include skipforms as well. > skipforms = \ > AR System Email Mailb*, \ > xxx, \ > ... > > After the first run, you may get errors on some forms. You may need to add > these to the skip-list and create separate config files for these forms. > Or you may do the export/import to arx-files for some things where you > need to modify the data extensively. > > There are definitely a couple of forms you want to skip, such as "AR > System Application State" and "AR System Email Mailbox Configuration". > > A recent addition to RRR|Chive is the setfields-parameter where you can > assign or modify data when you copy it: > setfields = \ > 'Status' = 5, \ > 'Priority' = 2, \ > 'ServerName' = EXACT("oldserver.xxx.com", "newserver.xxx.com") > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): > * 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. > >> I'm doing a three step install/upgrade process: >> Export/import the DB to new machines >> Upgrade Remedy on new machines >> Put New machines into production >> If I'm going to push data from an old system to a new system using >> RRRchive to capture the difference between the export and the go-live, I >> really need the data from all regular forms. I even want to capture all >> new users and groups, etc. It looks like a >> multipleforms = * >> splitsearch = YES >> transfertype = SYNCTOTARGET >> Will do this. Has anyone done this successfully? It makes me a little >> nervous >> >> Anne Ramey >> *********************************** >> E-mail correspondence to and from this address may be subject to the >> North >> Carolina Public Records Law and may be disclosed to third parties only >> by >> an authorized State Official. >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"