Well, that's an unfortunate fact that I'm afraid I don't know any way around. The bulk of the time is really going to be recovering and possibly cleaning the data that's been gathered since your last backup. Once you get that done, importing shouldn't take all that long, since I wouldn't think that most of your foundation data has changed all that much in a few days, and even a few thousand Incidents wouldn't take but an hour or two, tops. So you're really looking at history tables, work logs, etc., and the IM/PM/CR tables, and maybe a few others.
As far as data import tools, whether BMC's or Effective's, they're both intended to import NEW data, not data with a history. There are some fields that I don't think exist in the templates that would be necessary to import pre-existing records with history. And they don't deal with Incidents, Problems, etc. - just foundation data. So I don't know that I would waste my time down that rabbit hole. This is probably going to be a manual effort. I hope there's a good pizza place near your office - I'm afraid you'll be there a good part of the weekend. :-( Rick On Fri, Jun 6, 2008 at 12:21 PM, Moore, Christopher Allen < [EMAIL PROTECTED]> wrote: > ** > > Rick- thanks again for your advice! > > > > Our problem is that if we have to do this import by form, we're looking at > an incredible amount of time. I estimate an average of 30 minutes per form, > and with over 1500 forms on the server, and guessing at least 2/3 or them > could have been touched in the last week….you see how long this could take. > > > > A tech for BMC suggested a tool which was available as a patch- 9003- the > tool is ITSM Data Management. Its primary use is for doing server > migrations and moving data, but it could help us- I'm still reading through > the documentation on it. Unfortunately when trying to install it we got an > error that we were at an incompatible patch level, so I'm waiting to talk to > BMC again about it. > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook > *Sent:* Friday, June 06, 2008 1:57 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: backup and recovery > > > > ** The problem, Chris, is that it's all data. If it can be read by an AR > System, you can export it and import it. You may be able to get it from > your DBA, too, but unless you get it out in an ARS-readable format, you'll > have to import it that way as well, and that's going to be a bit > unpredictable, and probably unsupported. Have your DBA make a copy of the > DB as it sits now. > > > That will determine the last point in time where all of the tables, from > Company to Incident, were in sync with one another. Then you'll have to > export the data, either directly from the DB. Or perhaps you could get a > temp AR Server license, hook that up to the new DB, and use that to extract > the data into csv/arx or something. Then Import the data, starting with the > bottom end forms first (just like the order of migration in ITSM 6), i.e. > all of the base associated records first, and ending with the actual > Incidents, Changes, etc. Use the Admin console as a guide to the order of > the data restore. > > For $deity$'s sake, remember to import the existing GUIDs, or your data > relationships will probably not be clean. I would also recommend starting > with just a tiny slice of all of the form data as a practice run, because > sure as shooting, there will be some glitch in the code that overwrites a > GUID, or uses an Entry ID differently, or changes a Modified Date or > something, and that will fire workflow you don't intend. > > Workflow. Make sure that you turn off workflow that will fire on Merge, > unless you really want it to fire. I would turn off escalations, too, > because you don't want them firing on an incomplete data set. > > I'm sure I'm leaving something out, but that should get you in the > ballpark. > > Rick > > On Fri, Jun 6, 2008 at 11:31 AM, Moore, Christopher Allen < > [EMAIL PROTECTED]> wrote: > > ** > > Hey Rick- thanks! > > > > So the BMC tech said she doesn't know a way to do this, but here's my > question. We're recovering from our last known good configuration, Friday > night. In the meantime however we've had thousands of records updated. Is > there a way, for the entire DB (all forms) to extract just the data and not > attributes/configuration to import into our recovered database so we don't > have to go by form? > > > > Thanks! > Chris > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook > *Sent:* Friday, June 06, 2008 10:12 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: backup and recovery > > > > ** The Interface_Create form might be necessary to have your consoles be > populated correctly. I would check at least all of the table fields on each > of the main forms, and ensure that all of the feeding forms are also > updated. This will catch Assignment records, Work Entries, Templates, etc. > > Rick > > On Fri, Jun 6, 2008 at 8:00 AM, Moore, Christopher Allen < > [EMAIL PROTECTED]> wrote: > > ** > > Related to my last post- we're going to have to recover from a backup > created on Thursday night. The problem is that thousands of tickets have > been created since which we'd like to save. > > > > Does anyone have any advice on how to get those tickets? I've done > recoveries before, but never tried to capture data since the backup after > recovering. > > > > We're planning to just export from incident, change, problem, all work info > forms, user, people and import them- will that be enough? Any advice is > welcome! > > > > Thanks, > > Chris > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
