That isn't complete enough for ITSM 7.0 though. There are some tables (I don't have a complete list off the top of my head) that contain server references too. For example, one is the CAI Application Registry form which has the server name for each app installed. What I've done is develop a script to do a search and replace across my entire database, excluding tables like HPD_Help_Desk, CHG_Infrastructure_Change and BMC_Core_BaseElement so I don't mess up any real data.
Shawn Pierson -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, April 10, 2008 10:15 AM To: [email protected] Subject: Re: Replacing test data with live Here you go: exec sp_changedbowner 'sa' exec sp_dropuser 'ARAdmin' exec sp_changedbowner 'ARAdmin' exec sp_defaultdb 'ARAdmin', 'ARSystem' update field_table set tfServer = '@' update actlink_open set serverName = '@' update char_menu_query set server = '@' update char_menu_sql set server = '@' Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Randy Simon Sent: Thursday, April 10, 2008 8:31 AM To: [email protected] Subject: Re: Replacing test data with live Could you please share those scripts? I am having problems after I updated my DR server from the Prod DB. Embedded server references are not something I thought about. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, April 10, 2008 8:09 AM To: [email protected] Subject: Re: Replacing test data with live We do this often in our systems. The only thing I am aware of that is an issue is server references in the different databases. We have scripts that we execute to replace embedded server references. I might also add that I am in a SQL environment. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, April 10, 2008 8:03 AM To: [email protected] Subject: Replacing test data with live Dear List, We have two separate Remedy systems each with its own database, one a test/development system and the other a live/production system. We try to keep them in sync, but don't always succeed. Our dba is suggesting simply replacing the data in the test database with data from the live database. Are there any pitfalls that we should be aware of? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact us immediately and delete the material from any computer. Thank You. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
