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: [email protected] 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]<mailto:[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]<mailto:[email protected]>] On Behalf Of Rick Cook Sent: Friday, June 06, 2008 10:12 AM To: [email protected]<mailto:[email protected]> 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]<mailto:[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<http://www.rmsportal.com> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com<http://www.rmsportal.com> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com<http://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"

