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
Kelly Deaver
L-3 Stratis / FAA Contractor
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_-------- Original Message --------
Subject: Re: An efficient way to sync up data
From: pritch <[email protected]>
Date: Mon, June 07, 2010 2:48 pm
To: [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]>
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
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
