Hi,
Yes, a COPY+SYNCDELETED should yield the same result as a SYNCTOTARGET.
The old way (COPY+SYNCDELETED) does not care about the modify-timestamp,
which may be good in some cases. The drawback is that it copies everything
as opposed to changed records only.
You can do other things as well, if you want to combine existing data with
data from another source.
For example let us say that you have 3000 records in your target that you
want to keep, and 4000 records in your source that you need to get over to
the target, resulting in 7000 records:
transfertype = COPY
entryidmode = +5000
sorting = REVERSE
The 3000 records would have ids between 000000000000001 and
000000000003000, and the copied records will get ids from 000000000005001
and 000000000009000.
(The REVERSE sorting makes sure that record 000000000009000 is created
first, thus preventing active user of creating records that gets
overwritten in the middle of the transfer. You can also manually forward
the nextId to something like 10000 before you do this.)
If you use SYNCTOTARGET in where you want to keep existing data, you must
make sure that you have something to query on that does not exist in the
target already:
qual = 'Company' = "RRR Scandinavia"
transfertype = SYNCTOTARGET
entryidmode = +5000
sorting = REVERSE
As to details about ITSM versions and automatically created workflow
depending on data, I happily refer you to Strauss and the other ITSM
experts ;-)
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.
> 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:[email protected]] On Behalf Of Ramey, Anne
> Sent: Tuesday, January 11, 2011 12:28 PM
> To: [email protected]
> 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
> [email protected]
> 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:[email protected]] On Behalf Of Misi Mladoniczky
> Sent: Tuesday, January 11, 2011 2:17 AM
> To: [email protected]
> 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:[email protected]] On Behalf Of Misi Mladoniczky
>> Sent: Saturday, January 08, 2011 6:54 AM
>> To: [email protected]
>> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
