We've done this and developed a little document with all of the references in ARS and ITSM to the production server and how/when they need to be changed during/after the sync of the DB. It's worked well for us once we worked out the details.
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. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kelly Deaver Sent: Monday, June 07, 2010 4:25 PM To: [email protected] Subject: Re: An efficient way to sync up data ** You can have a problem with copying the database if you have the ITSM apps, use the email server and any number of other places where configuration data is stored in the database. References to your production server will now live on your test server. I have personally seen this situation and had the test server looking over in the production server to send email notification.. we were wondering why they were all going out twice! Kelly Deaver L-3 Stratis / FAA Contractor [email protected]<mailto://[email protected]> (ARSlist mail) [email protected]<mailto:[email protected]> (Business mail) -------- Original Message -------- Subject: Re: An efficient way to sync up data From: pritch <[email protected]<mailto://[email protected]>> Date: Mon, June 07, 2010 2:48 pm To: [email protected]<mailto://[email protected]> Hi Mary, When I've done this in the past, we've copied the database from production back to test, removed any 'sensitive' data and then migrated any coding updates that needed to be changed. A couple of items to watch for: - You need to make sure your ARAdmin ID to the DB is the same (or have it reset) - All your workflow needs to be server independent (you can export to a def file and evaluate) - All test user accts will need to be reset (I've usually exported those and imported after the database is restored. - probably need to check external interfaces and application settings to make sure they are pointed properly. With all the ancillary forms that are used in remedy, I've found this to be the easiest way to get all the data moved intact. pritch On Mon, 7 Jun 2010 12:05:40 -0700, Mary Estrada <[email protected]<mailto://[email protected]>> wrote: > Hi, > > We are looking for suggestions to sync up all data, i.e. foundation, > configuration & transaction data from our production server onto our test > server where we need all the prod-like data and keeping all record IDs in > their forms. Your feedback is gratefully appreciated. > > Thanks, > > ~Mary > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org<http://www.arslist.org> > attend wwrug10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the > Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are" _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
