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 <guilla...@dcshq.com> To: arslist <arslist@ARSLIST.ORG> 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) [arslist@ARSLIST.ORG] on behalf of Easter, David [david_eas...@bmc.com] Sent: Sunday, January 30, 2011 11:50 AM To: arslist@ARSLIST.ORG 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 ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
