To load the SCADA measurements staging tables into the production (run-time) SCADA measurements tables, the following command must be run:

When this command is invoked, DDService will merge the scada_measurements_st table into the analog_measurements and digital_measurements tables, merge the scada_controls_st table into the scada_controls table (adding and removing rows as necessary), and load the updated scada_controls, analog_measurements and digital_measurements tables into memory.

When new measurements are added, all fields in the production measurements table are populated from the staging tables.

When existing measurements are updated, all fields are copied from the scada_measurements_st staging table except the following columns because these columns can contain operator entered data (operator override values for example) - and should not be overwritten. Indeed this is the primary reason for using the staging table - to avoid overwriting these run-time columns: