All valid things to take into consideration, but with proper work instructions it all becomes routine.
On Mon, 7 Jun 2010 13:25:28 -0700, Kelly Deaver <kdea...@kellydeaver.com> wrote: > ** 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 kdea...@kellydeaver.com [1] (ARSlist mail) > �(Business mail) � � -------- Original Message -------- > Subject: Re: An efficient way to sync up data > From: pritch > Date: Mon, June 07, 2010 2:48 pm > To: arslist@ARSLIST.ORG [3] > > 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 > 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 [5] >> attend wwrug10 www.wwrug.com [6] ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org [7] > attend wwrug10 www.wwrug.com [8] ARSlist: "Where the Answers Are" > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > Links: > ------ > [1] mailto://kdea...@kellydeaver.com > [2] mailto://pri...@ptd.net > [3] mailto://arslist@ARSLIST.ORG > [4] mailto://mestr...@blizzard.com > [5] http://www.arslist.org > [6] http://www.wwrug.com > [7] http://www.arslist.org > [8] http://www.wwrug.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"