This page notes issues and planning for the project to migrate LCLS control system critical sub-schema from SLACPROD and other instances, to within the LCLS controls network.
The following are two diagrams outlining the architecture and data flow predicted for the control system relational database system.
The first is a total summary just showing the data flow between db instances: stage -> dev/QA -> prod -> failover. This is to emphasize that edits are made in "stage", and the one way data flow from stage -> dev/QA and two way flow from dev/QA to prod.
A work up the Use Cases which implement schema, code and data flow between the databases instances. Shows that: