Hi Shyam, Sorry, I mis-understood what you were looking for. I have worked at a few sites where the DB copy was mainly done so that the test environment had production data to be tested with. Sorry, but at least you know of rrrchive if you didn't earlier.
For DB copies with ITSM 7.0.3 (AIE, Incident, Problem, Change, Asset and CMDB) these are the tables that I am aware of that hold server name references. I had written a stored procedure that took a search string and traversed through all tables and columns within the tables of a specific database and returned the table name followed with the column name. This gave me the tables and columns referenced below. Report (field name: Server) BMC.CORE.CONFIG:BMC_FederatedInterface_ (Field name: ARServerName) EIE:ApplicationSettings (field name: Help File Path) EIE:DataExchange (field names: Instance Name, zTmpInstanceAlias) EIE:BackUpLoadFlag (field names: Host, Internal Instance Name,InstanceName) EIEORA:RuleHelper (field name: Path) - holds the path to the EIE bin directory so may or may not have the server name referenced here depending on how you did your install. CAI:AppRegistry (field name: Server) In addition to these there are also meta-data tables like field_table etc. that may need server references removed. Hope this helps. Saby From:Action Request System >> discussion list(ARSList) [mailto:[email protected]] On Behalf Of >> Shyam Attavar >>Sent: Friday, March 05, 2010 2:00 >> PM >>To: [email protected] >>Subject: Re: Refreshing the >> DB for ITSM 7.1.0 >> >>** >>Thanks for the suggestion >> Saby, >> >>But I am looking for a way to move customizations only and not >> the data. >> >>Thanks to Joe D'Souza for his suggestion and I will most >> likely be using that for our >> needs. >> >>Regards, >>-- >>Shyam >> >> ________________________________ >>From:Sabyson Fernandes >> <[email protected]> >>To: [email protected] >>Sent: >> Fri, March 5, 2010 6:08:39 AM >>Subject: Re: Refreshing the DB for >> ITSM 7.1.0 >> >>** >>Hi Shyam, >> >>Have you looked into rrrChive? Its a >> great utility for copying over data from one server to another. I use it >> currently for copying data from a production server to a archive server >> and >> will shortly be using it to copy production data to our UAT environment >> so >> that users can test enhancements/fixes with production data. >> >> >>Regards, >>Saby >> >> ________________________________ >>From:Shyam Attavar >> <[email protected]> >>To: >> [email protected] >>Sent: Thu, March 4, 2010 4:59:45 >> PM >>Subject: Refreshing the DB for ITSM 7.1.0 >> >>** >>Dear Listers, >> >>I >> have a need to refresh the production database back onto a test >> environment >> we are building. Since there have been quite a few customizations, we >> would >> like to get to a point where we can start leveraging the Test environment >> without having to individually migrate the customizations over. >> >>If >> refreshing the DB from production environment is considered risky due to >> the >> various notifications, escalations and approvals that might be pending, >> we >> can even refresh from our development server. >> >>Here's the >> environment: >>ITSM 7.1.0 (except SRM) >>ARS 7.1.0 Patch 6 running in a >> server group with four nodes on RHEL >>Oracle 10gR3 RAC running on >> RHEL >> >>Has anyone attempted something like this and has been >> comfortable with the refresh process. I have done this in the past on >> ITSM >> 6.x running on Oracle. I do realize exporting the ARADMIN schema from one >> instance and importing into another instance would get me started. >> However, >> I am more concerned with the data driven nature of ITSM 7.1.0 and there >> is >> more to the refresh process than meets the eye. >> >>I have never >> attempted this on ITSM 7.1.0 - hence my concern and posting to the >> list. >> >>Any words of advice, things "to do", things "not to do", things >> to "watch out for", or not do this at all. >> >>Any feedback is >> welcome. >> >>Thanks in >> advance, >>-- >>Shyam_Platinum Sponsor: [email protected] ARSlist: "Where the Answers >>Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
