Re: syncing environments
Has anyone done this with eie and ITSM and been successful? Anne Ramey Remedy System Administrator State of North Carolina Office of Information Technology Services (ITS) Service Delivery Division ITSM ITAM Services Office (919) 754-6521 Home Office (919) 842-5420 ITS Service Desk : (919) 754-6000 or (800) 722-3946 anne.ra...@its.nc.govmailto:anne.ra...@its.nc.gov http://its.state.nc.ushttp://its.state.nc.us/ RHCE, ITIL Foundation *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roger Justice Sent: Tuesday, August 11, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: syncing environments ** The best way is what you had probelms with DB restore. The Migrator will provide a way to transfer the underlieing data or you can do a lot of exports/imports. Some others may have additional methods. -Original Message- From: Ramey, Anne anne.ra...@its.nc.gov To: arslist@ARSLIST.ORG Sent: Tue, Aug 11, 2009 9:46 am Subject: syncing environments ** We are at the point where we need to sync the data from our production system back into out test system--primarily for performance testing at this point. The problem is how to accomplish this. Last time we did this, we copied the DB over…and ended up with a lot of trouble. We had to re-install EIE three times to get it working on test again. What is the best way to get the data over from Production without breaking test? Remedy 7.1, ITSM 7.0.3, EIE, Config Disc. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
Re: syncing environments
Based on what is I think you are doing, I will summerize and then post an idea. Summary: you want the same data EIE exchange on production as Test. Why not just reisntall EIE with a different instance name/location and point it to Test. CM is then pointing to -- Prod , and pointing to -- Dev. FD/TD: you will need to install a complete seperate instance of FD/TD // and 1 additional SQL server instance to sycro to a testbed. Might be a little heavy for 2 sql servers and 2 FD/TD instances on the same box.. FYI. Is this what you were thinking? On Wed, Aug 12, 2009 at 8:10 AM, Ramey, Anne anne.ra...@its.nc.gov wrote: Has anyone done this with eie and ITSM and been successful? Anne Ramey Remedy System Administrator State of North Carolina Office of Information Technology Services (ITS) Service Delivery Division ITSM ITAM Services Office (919) 754-6521 Home Office (919) 842-5420 ITS Service Desk : (919) 754-6000 or (800) 722-3946 *anne.ra...@its.nc.gov* anne.ra...@its.nc.gov *http://its.state.nc.us* http://its.state.nc.us/ RHCE, ITIL Foundation *** *E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official.* *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Roger Justice *Sent:* Tuesday, August 11, 2009 9:58 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: syncing environments ** The best way is what you had probelms with DB restore. The Migrator will provide a way to transfer the underlieing data or you can do a lot of exports/imports. Some others may have additional methods. -Original Message- From: Ramey, Anne anne.ra...@its.nc.gov To: arslist@ARSLIST.ORG Sent: Tue, Aug 11, 2009 9:46 am Subject: syncing environments ** We are at the point where we need to sync the data from our production system back into out test system--primarily for performance testing at this point. The problem is how to accomplish this. Last time we did this, we copied the DB over…and ended up with a lot of trouble. We had to re-install EIE three times to get it working on test again. What is the best way to get the data over from Production without breaking test? Remedy 7.1, ITSM 7.0.3, EIE, Config Disc. Anne Ramey *** *E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official.* _Platinum Sponsor: *rmisoluti...@verizon.net* rmisoluti...@verizon.netARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: syncing environments
Anne You’ll need to back up your EIE data first. Once the db has been restored you’ll need to delete the existing data then import your EIE data using an arimport command line. If you wish to restore your server with a copy of the EIE data, then the important form to backup is EIE:BackupDataLoadFlag (IIRC). Once the db restore is done, replace the entries with your backed up file. Matt From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: 12 August 2009 13:10 To: arslist@ARSLIST.ORG Subject: Re: syncing environments Has anyone done this with eie and ITSM and been successful? Anne Ramey Remedy System Administrator State of North Carolina Office of Information Technology Services (ITS) Service Delivery Division ITSM ITAM Services Office (919) 754-6521 Home Office (919) 842-5420 ITS Service Desk : (919) 754-6000 or (800) 722-3946 mailto:anne.ra...@its.nc.gov anne.ra...@its.nc.gov http://its.state.nc.us/ http://its.state.nc.us RHCE, ITIL Foundation *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roger Justice Sent: Tuesday, August 11, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: syncing environments ** The best way is what you had probelms with DB restore. The Migrator will provide a way to transfer the underlieing data or you can do a lot of exports/imports. Some others may have additional methods. -Original Message- From: Ramey, Anne anne.ra...@its.nc.gov To: arslist@ARSLIST.ORG Sent: Tue, Aug 11, 2009 9:46 am Subject: syncing environments ** We are at the point where we need to sync the data from our production system back into out test system--primarily for performance testing at this point. The problem is how to accomplish this. Last time we did this, we copied the DB over…and ended up with a lot of trouble. We had to re-install EIE three times to get it working on test again. What is the best way to get the data over from Production without breaking test? Remedy 7.1, ITSM 7.0.3, EIE, Config Disc. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _Platinum Sponsor: mailto:rmisoluti...@verizon.net rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: syncing environments
Matt's suggestion worked for an installation that I worked with and eliminates having to reinstall AIE/EIE to reestablish the instances. -Original Message- From: Matt Worsdell m...@worsy.co.uk To: arslist@ARSLIST.ORG Sent: Wed, Aug 12, 2009 9:54 am Subject: Re: syncing environments ** Anne You’ll need to back up your EIE data first. Once the db has been restored you’ll need to delete the existing data then import your EIE data using an arimport command line. If you wish to restore your server with a copy of the EIE data, then the important form to backup is EIE:BackupDataLoadFlag (IIRC). Once the db restore is done, replace the entries with your backed up file. Matt From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: 12 August 2009 13:10 To: arslist@ARSLIST.ORG Subject: Re: syncing environments Has anyone done this with eie and ITSM and been successful? Anne Ramey Remedy System Administrator State of North Carolina Office of Information Technology Services (ITS) Service Delivery Division ITSM ITAM Services Office (919) 754-6521 Home Office (919) 842-5420 ITS Service Desk : (919) 754-6000 or (800) 722-3946 anne.ra...@its.nc.gov http://its.state.nc.us RHCE, ITIL Foundation *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roger Justice Sent: Tuesday, August 11, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: syncing environments ** The best way is what you had probelms with DB restore. The Migrator will provide a way to transfer the underlieing data or you can do a lot of exports/imports. Some others may have additional methods. -Original Message- From: Ramey, Anne anne.ra...@its.nc.gov To: arslist@ARSLIST.ORG Sent: Tue, Aug 11, 2009 9:46 am Subject: syncing environments ** We are at the point where we need to sync the data from our production system back into out test system--primarily for performance testing at this point. The problem is how to accomplish this. Last time we did this, we copied the DB over…and ended up with a lot of trouble. We had to re-install EIE three times to get it working on test again. What is the best way to get the data over from Production without breaking test? Remedy 7.1, ITSM 7.0.3, EIE, Config Disc. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net=2 0ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: syncing environments
I just did a refresh of my test system. I copied over the DB and purged the license; applied a new license and it works like a charm. (I do have Email turned off b/c I don't want users to get emails from testing server). The first time, I did this I copied we took a server snap shot and db snap shot and created a virtual server. The database was put on a different SQL server. Then I had to go into the server and rename registry keys and system folders to the testservername. Also did this in the ar.cfg file. What I can't get to work after doing the copy is the mid-tier.. An alternative would be to use Remedy Migrator and migrate the objects that are different; or entire applications. ARS7.1 ITSM7.0 P2 SQL2005 -Marcelo- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Tuesday, August 11, 2009 8:46 AM To: arslist@ARSLIST.ORG Subject: syncing environments ** We are at the point where we need to sync the data from our production system back into out test system--primarily for performance testing at this point. The problem is how to accomplish this. Last time we did this, we copied the DB over...and ended up with a lot of trouble. We had to re-install EIE three times to get it working on test again. What is the best way to get the data over from Production without breaking test? Remedy 7.1, ITSM 7.0.3, EIE, Config Disc. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: syncing environments
The best way is what you had probelms with DB restore. The Migrator will provide a way to transfer the underlieing data or you can do a lot of exports/imports. Some others may have additional methods. -Original Message- From: Ramey, Anne anne.ra...@its.nc.gov To: arslist@ARSLIST.ORG Sent: Tue, Aug 11, 2009 9:46 am Subject: syncing environments ** We are at the point where we need to sync the data from our production system back into out test system--primarily for performance testing at this point. The problem is how to accomplish this. Last time we did this, we copied the DB over…and ended up with a lot of trouble. We had to re-install EIE three times to get it working on test again. What is the best way to get the data over from Production without breaking test? Remedy 7.1, ITSM 7.0.3, EIE, Config Disc. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: syncing environments
Anne, This kind of functionality is built-into our ESS @ Work solution. Our Configuration Data Management (CDM) application allows our Administrators to synchronize environments without the fear of losing precious data. You can easily compare data between servers and then transfer as required, we do data integrity checks and track updates via a Change Log. This is not a bolt-on application for ESS, it is built-in. Also note that there is no additional cost for ESS @ Work on a test or development server adding additional value to an already mature and proven enterprise solution. In case you are interested in how this works: http://www.buoyantsolutions.net/ESS_Info/ESS%20Configuration%20Data%20Manage ment%20Guide.pdf Contact me off-list if you'd like to schedule a demonstration or visit our website. Regards...Gidd _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Tuesday, August 11, 2009 6:46 AM To: arslist@ARSLIST.ORG Subject: syncing environments ** We are at the point where we need to sync the data from our production system back into out test system--primarily for performance testing at this point. The problem is how to accomplish this. Last time we did this, we copied the DB over.and ended up with a lot of trouble. We had to re-install EIE three times to get it working on test again. What is the best way to get the data over from Production without breaking test? Remedy 7.1, ITSM 7.0.3, EIE, Config Disc. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are