Increment Summary Version

OVERVIEW:

• Generate Summary Tables – “Maintenance Version”

PROCESS:

1. Insert a new ‘fm.Summary_Version’ entry with ‘is_live’ = False

   insert into fm.summary_version (version, Last_updated, is_live, Note) values ('',getdate(), 0, '');

2. Update config ‘fm.summary.DbVersion’.

   update config set value = '', note = '', updated = getdate() where component = 'fm.summary';

3. Generate Summary Tables

   exec fm.usp_update_Summary_Historical_All;

4. Copy to both prod01 and gsi.myersmediagroup.com:

   use global_swxl; exec [dbo].[usp_global_summary_update_all] @site_id = ?;