On Fri, Apr 08, 2016 at 03:02:19PM -0400, Boris Epstein wrote: > Hello listmates, > > Here is what I have in mind. > > Let us say I have a production RT instance. Let us call it rt_prod. Let us > also say I want to run a staging instance on which I would be testing new > versions, extensions, etc. Let us call is rt_stag. > > Is there a way to synchronize the to with regard to actual ticket data - > i.e., make it so that once any modification is made on the production one > (rt_prod), for instance, the same is reflected on staging (rt_stag). I may > even want to do it both ways. > > Any way to do something like this - or am I just dreaming? > > Thanks. > > Boris.
Hi Boris, Read through the upgrade documentation and check out the changes introduced in the schema during the process. Not having done so, if the changes are in some sense one-to-one, you may be able to have your production data pushed into your test system with judicious scripting, triggers, views,.... It may be more useful to script the upgrade process completely for the DB and then update it once a day with the latest information. Going both ways would be EXTREMELY challenging. Let us know if you get something like this working, I think it would be of interest to others. Regards, Ken --------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016
