Hi,
Just a note from an RRR|Chive standpoint. It does not use indexes on
'Modify Date' if you are doing SYNCTOTARGET.
If you want to find DELETED records in the source, that also needs
deletion in the target, an index on 'Modify Date' will not help us,
because deleted records are not indexed...
If you just want to find modified/created records, it could help you, but
it would require that you use a specified qualification such as ('Modified
Date' > "2011-01-01 00:00:00") to find the records.
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.
> Ok, so big difference. Since you were referring to records instead of
> entries, i thought you were doing something at the database level, which i
> am in my case. But still, you would think that the Create Date and
> Modified Date would be indexed so the delta would would execute is a split
> of a second.
>
> Mr Misi's tool RRRchive could take advantage of that too....
>
> I would like to see some real world scenarios of the Delta Data Migration
> tool, for instance if BMC is planning to use that with the Remedy
> On-Demand customers
>
> ________________________________
> From: Action Request System discussion list(ARSList) [[email protected]]
> on behalf of Roger Justice [[email protected]]
> Sent: Monday, January 31, 2011 4:41 PM
> To: [email protected]
> Subject: Re: Delta Data Migration tool (was Long running ITSM 7.6 upgrade)
>
> ** Remember I am doing API to API and insuring data integrity including
> relationships between different versions of ARS/ITSM.
>
>
>
> -----Original Message-----
> From: Guillaume Rheault <[email protected]>
> To: arslist <[email protected]>
> Sent: Mon, Jan 31, 2011 4:21 pm
> Subject: Re: Delta Data Migration tool (was Long running ITSM 7.6 upgrade)
>
> **
> 100K records per hour is not a lot, it's actually pretty low....
> With database links, I can do 2 million records per hour, and this is by
> dumping all the records from one table to the other which involves a full
> table scan (so not dealing with deltas here)
>
> I would hope that in ITSM 7.6.4, the Create date and Modified Date were
> indexes out of the box.
> I am sure that indexing these fields would improve performance
> dramatically by avoiding all the full table scans.
>
> Guillaume
>
> ________________________________
> From: Action Request System discussion list(ARSList)
> [[email protected]<mailto:[email protected]>] on behalf of Roger
> Justice [[email protected]<mailto:[email protected]>]
> Sent: Monday, January 31, 2011 4:09 PM
> To: [email protected]<mailto:[email protected]>
> Subject: Re: Delta Data Migration tool (was Long running ITSM 7.6 upgrade)
>
> ** When I used it I did not make any new indexes and I was able to move,
> on a good network, over 100K records per hour.
>
>
>
> -----Original Message-----
> From: Guillaume Rheault <[email protected]<mailto:[email protected]>>
> To: arslist <[email protected]<mailto:[email protected]>>
> Sent: Mon, Jan 31, 2011 3:57 pm
> Subject: Delta Data Migration tool (was Long running ITSM 7.6 upgrade)
>
> **
> Hi David,
>
> Will the Create Date and Modified Date(field IDs 3 and 6) need to be
> indexed in all the forms in the source system, so the delta data migration
> tool can quickly fetch the entries created or updated from a specific
> timestamp, to migatre the delta data into the new production system?
>
> Guillaume
>
> ________________________________
> From: Action Request System discussion list(ARSList)
> [[email protected]<mailto:[email protected]>] on behalf of Easter,
> David [[email protected]<mailto:[email protected]>]
> Sent: Sunday, January 30, 2011 11:50 AM
> To: [email protected]<mailto:[email protected]>
> Subject: Re: Long running ITSM 7.6 upgrade
>
> Two recent capabilities are intended to assist with these kind of
> situations.
>
> 1. The ITSM Preconfigured Suite Stack Installer. The Suite Stack
> Installer (SSI) enables a fresh install of the entire ITSM Suite to be
> installed in an hour or two. All of the applications and configurations
> are pre-loaded in a DB image provided by BMC – so the installer need only
> lay down the binaries and copy the DB image into an empty DB instance
> provided by you. Time has been reduced from up to 60 hours down to 1-2
> hours for a fresh install. While the SSI cannot be used for upgrades, it
> is good for creating a staging, development or POC system.
> 2. Delta Data Migration. The ITSM Suite 7.6.04 includes utilities
> that enable you to migrate data from your production environment to a
> staging/development server until you are ready to switch over from
> development to production. Basically, you’ll create a parallel system in
> staging/development that will eventually become your production server.
> When your maintenance window arrives, you can bring down both systems,
> transfer the last bit of user data (which should be only a couple of hours
> or, at most days) and then bring up the staging server as your new
> production server. Downtime has been reduced to 4 hours or less using
> this methodology.
>
> -David J. Easter
> Manager of Product Management, Remedy Platform
> BMC Software, Inc.
>
> The opinions, statements, and/or suggested courses of action expressed in
> this E-mail do not necessarily reflect those of BMC Software, Inc. My
> voluntary participation in this forum is not intended to convey a role as
> a spokesperson, liaison or public relations representative for BMC
> Software, Inc.
>
> _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the
> Answers Are"_
> _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the
> Answers Are"_
> _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the
> Answers Are"_
> _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"
