Generate GSI Tables (Step 12)

DEPENDENCIES:

• Migration ds.swxl-express-panel 0021 applied.

OVERVIEW:

• Generate Summary Tables – “First Update”

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;
   declare @site int set @site = (select id from site where pos = '{POS}')
   
   -- Prod01 (run on prod01.mmg.local)
   use global_swxl;
   exec [dbo].[usp_global_summary_update_all] @site_id = @site;
   update dbo.site set last_swxl_update = getdate() where id = @site;
   
   use seo_toolbar;
   update dbo.site set last_swxl_update = getdate() where id = @site;
   
   -- GSI (run on gsi.myersmediagroup.com)
   use global_swxl;
   exec [dbo].[usp_global_summary_update_all] @site_id = @site;
   update dbo.site set last_swxl_update = getdate() where id = @site;