Re: Replacing test data with live
Shawn, Sorry I should have included the caveat that we are a 100% custom shop, for now anyway. Thanks, 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 Pierson, Shawn Sent: Thursday, April 10, 2008 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: Replacing test data with live 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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 se
Re: Replacing test data with live
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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"
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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"
Re: Replacing test data with live
As well as the comments others have made, bear in mind that in v 7 the server licenses are stored in the database, so you may need to reapply the dev/test license. If the DB copy is something you propose to do regularly it's probably best to apply bother server licenses to your production database, then the dev/test box will already have the proper license applied when you copy it over. David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, April 10, 2008 1:03 PM To: arslist@ARSLIST.ORG 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"
Re: Replacing test data with live
Hi, When I do this, I use RRR|Chive. This allows for differences in the actual application/definitions. This sample script would sync your production server to the test server with the exception of some forms: source_server= prod source_user = Demo source_password = target_server= test target_user = Demo target_password = target_disabledeletefltr = YES target_disablemergefltr = YES multipleforms= * skipforms= \ Application Pending, \ Application Statistics, \ Application Statistics Configuration, \ AR System User Preference, \ AR System User Central File, \ AR System Administrator Preference, \ AR System Email Mailbox Configuration, \ Report, \ Server Events, \ Server Statistics, \ User qual = SPLITAUTO transfertype = SYNCTOTARGET logfile = rrrchive.log loglevel = NOTICE progressbar = YES Download and configure at: https://www.rrr.se/cgi/rrrchive/main Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > 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 > > -- > This message was scanned by ESVA and is believed to be clean. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Replacing test data with live
Remember to stop the Email Engine before you restore the database and disable the mailbox configuration(or replace them with you test mailboxes) before you start the emailengine again.. /Rune Sorlid 2008/4/10, Randy Simon <[EMAIL PROTECTED]>: > > 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: arslist@ARSLIST.ORG > 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: arslist@ARSLIST.ORG > 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"
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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"
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: arslist@ARSLIST.ORG 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"
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