A new Shared Reports solution has been added to tessituranetwork.com.
This script contains sample updates to T_DEFAULTS and other database tables that are often performed following a Live-to-Test copy. Examples include updating API references to point to Test APIs instead of Live APIs, deactivating scheduled report jobs to prevent reports from inadvertently being sent from Test, and clearing out TR_MACHINE_SETTINGS to prevent EMV transactions from being performed in Test. To use this script, you will need to go through it and update the various settings to match your Test environment.
The script can be found at:
https://www.tessituranetwork.com/en/Files/Shared-Reports/Sample-Updates-Following-TEST-Refresh
Hello Bryan.
Would it also be necessary to do something with the "T_TEMPLATE_QUEUE" table for a live to test script??
I can see that the table is set up to queue template emails for the future, with the queue_dt column (as opposed to the processed_dt)... However I am not aware of any stock processes out of Tessitura that would utilize that... Perhaps it might in the future??
In any case, could that be something that needs to be halted out of a test environment, similar to the scheduled reports, to make sure that these do not go out automatically from a test environment??