Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

In some cases, it is necessary or useful to copy a production database for testing, support or training.   When you restore a database backup into a support instance , it becomes an exact replica of the district's production instance.  This is a positive thing for testing and experimentation.  However, the are several potential problems when a support instance is created, namely:

  • All jobs scheduled in the production instance will also execute in the support instance
  • Any notifications (email or FTP, etc.) will also be executed and sent from the support instance

For example, if a district has reports scheduled to email a given report every morning at 6:00am, then, by default, both the production and support instance will execute the job and delivery the report.  The receiving user may not understand why they are getting multiple copies and the duplicate reports will not match (as the support instance and production instance instances diverge).

To solve this problem, the USxS-R application applications contain a global configuration object called "APPLICATION_INSTANCE_TYPE" which allow the applications to be configured for different default modes.  The available modes are:

Instance Type
ProductionDefault production mode
SupportTypically a temporary copy of a given districts production data for resolving support issues
TrainingA training instance typically contains anonymized data


A Demo instance typically contains anonymized data
DevelopmentReserved for use by the SSDT

In addition to this global parameter, the are two finer grained configuration options available:


Page properties

Related issues