[rt-users] data replication RT server to RT server

[ktm at rice.edu]

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