I just recently copied my PROD database to DEV in order to prepare for an upgrade. I know that there are some tables that store server info (i.e. for the agent). I need to know what needs to be updated so that my DEV instance will not be pointing to anything in PROD.
1. Logon to the stat dev agent machine.
2. Navigate to app\server\default\deploy and locate the file called stat-ds.xml file
3. Make sure all the information in the file is for the stat dev db including the STAT password.
4. Startup the stat dev agent and it should update the STAT_AGENT table to point to stat dev host instead of stat prod host