Skip to content

Instantly share code, notes, and snippets.

@blacktambourine
Created June 23, 2016 02:33
Show Gist options
  • Save blacktambourine/cce09b8eb92e45d469c2ed22a461030b to your computer and use it in GitHub Desktop.
Save blacktambourine/cce09b8eb92e45d469c2ed22a461030b to your computer and use it in GitHub Desktop.
SQL Statements need to rebuild Sitecore Analytics Reporting SQL Database
/****** Analytics Rebuild "waiting to receive data" Step ******/
INSERT INTO
[Sitecore_AnalyticsSecondary].[dbo].[CampaignActivityDefinitions]
SELECT * FROM [Sitecore_Analytics].[dbo].[CampaignActivityDefinitions]
INSERT INTO
[Sitecore_AnalyticsSecondary].[dbo].GoalDefinitions
SELECT * FROM [Sitecore_Analytics].[dbo].GoalDefinitions
INSERT INTO
[Sitecore_AnalyticsSecondary].[dbo].OutcomeDefinitions
SELECT * FROM [Sitecore_Analytics].[dbo].OutcomeDefinitions
INSERT INTO
[Sitecore_AnalyticsSecondary].[dbo].MarketingAssetDefinitions
SELECT * FROM [Sitecore_Analytics].[dbo].MarketingAssetDefinitions
INSERT INTO
[Sitecore_AnalyticsSecondary].[dbo].Taxonomy_TaxonEntity
SELECT * FROM [Sitecore_Analytics].[dbo].Taxonomy_TaxonEntity
INSERT INTO
[Sitecore_AnalyticsSecondary].[dbo].Taxonomy_TaxonEntityFieldDefinition
SELECT * FROM [Sitecore_Analytics].[dbo].Taxonomy_TaxonEntityFieldDefinition
INSERT INTO
[Sitecore_AnalyticsSecondary].[dbo].Taxonomy_TaxonEntityFieldValue
SELECT * FROM [Sitecore_Analytics].[dbo].Taxonomy_TaxonEntityFieldValue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment