Disabling / Uninstalling uMarketingSuite
We have no idea why you would ever want this, but still... If you want to do this you can of course uninstall the uMarketingSuite package.
Uninstall via NuGet
You can uninstall the package in the same way you've installed it.
- Via the NuGet package manager
- Or via the Package manager console via the command: uninstall-package uMarketingSuite
Uninstall via Packages section
If you've installed the uMarketingSuite via the Packages section in Umbraco you can go that section. In the section go to the tab "Installed" and look for the uMarketingSuite. Here you can uninstall the package.
Known issues
At this moment both uninstall options will not actually delete all files and all tables. This is a known issue and on our backlog but it has no priority at the moment (because who wants to delete the uMarketingSuite anyway).
A workaround is as follows:
- Delete all files in the following folders
- /App_Plugins/uMarketingSuite/*
- /Assets/uMarketingSuite/*
- /Config/uMarketingSuite/*
- Delete the following files in your /bin/-folder
- /bin/uMarketingSuite.Business.dll
- /bin/uMarketingSuite.Common.dll
- /bin/uMarketingSuite.Data.dll
- /bin/uMarketingSuite.Licensing.package.dll
- /bin/uMarketingSuite.Web.dll
- Delete the datatypes in the folder uMarketingSuite in the Settings section of your Umbraco installations
- uMarketingSuite - Node picker
- uMarketingSuite - Time input
- The uMarketingSuite folder
- Delete the folder uMarketingSuite and its contents in the Media section.
- Run this SQL Script to remove all tables
Dropping all foreign keys first:
/*
WB 10-04-2020: Initial script that drops all uMarketingSuite-tables
JS 15-05-2020: First drop all foreign keys to prevents errors
*/
-- Drop foreign keys
IF OBJECT_ID('uMarketingSuiteAbTestingAbTest', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTest] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTest_uMarketingSuiteAbTestingAbTestProject]
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTest] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTest_uMarketingSuiteAnalyticsGoal]
END
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestContentType', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTestContentType] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTestContentType_uMarketingSuiteAbTestingAbTest]
END
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestUmbracoPageVariant', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTestUmbracoPageVariant] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTestUmbracoPageVariant_uMarketingSuiteAbTestingAbTest]
END
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestVariant', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTestVariant] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTest_uMarketingSuiteAbTestingAbTestVariant]
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTestVariant] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTestVariant_uMarketingSuiteAbTestingAbTest]
END
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestVisitorToVariant', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTestVisitorToVariant] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTestVisitorToVariant_uMarketingSuiteAbTestingAbTest]
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTestVisitorToVariant] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTestVisitorToVariant_uMarketingSuiteAbTestingAbTestVariant]
ALTER TABLE [dbo].[uMarketingSuiteAbTestingAbTestVisitorToVariant] DROP CONSTRAINT [FK_uMarketingSuiteAbTestingAbTestVisitorToVariant_uMarketingSuiteAnalyticsVisitor]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsAnnotationPageVariant', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsAnnotationPageVariant] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsAnnotationPageVariant_annotationId]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsBrowserVersion', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsBrowserVersion] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsBrowserVersion_uMarketingSuiteAnalyticsBrowser]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsDevice', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsDevice] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsDevice_uMarketingSuiteAnalyticsBrowserVersion]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsDevice] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsDevice_uMarketingSuiteAnalyticsOperatingSystemVersion]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsGoalCompletion', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsGoalCompletion] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsGoalCompletion_uMarketingSuiteAnalyticsGoal]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsGoalCompletion] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsGoalCompletion_uMarketingSuiteAnalyticsPageview]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsIpAddress', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsIpAddress] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsIpAdress_uMarketingSuiteAnalyticsLocation]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsIpFilterIpAddress', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsIpFilterIpAddress] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsIpFilterIpAddress_ipFilterId]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsIpLocation', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsIpLocation] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsIpLocation_uMarketingSuiteAnalyticsIpCity]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsIpLocation] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsLocation_uMarketingSuiteAnalyticsCountry]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsIpLocation] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsLocation_uMarketingSuiteAnalyticsCounty]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsIpLocation] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsLocation_uMarketingSuiteAnalyticsProvince]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsLinks', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsLinks] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsLinks_uMarketingSuiteAnalyticsPage_id]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsLinks] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsLinks_uMarketingSuiteAnalyticsPageview_id]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsOperatingSystemVersion', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsOperatingSystemVersion] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsOperatingSystemVersion_uMarketingSuiteAnalyticsOperatingSystem]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsPage', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsPage] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsPage_uMarketingSuiteAnalyticsPage]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsPage] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsPage_uMarketingSuiteAnalyticsSearchEngine]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsPageEvent', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsPageEvent] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsPageEvent_uMarketingSuiteAnalyticsPageview]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsPageview', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsPageview] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsPageView_uMarketingSuiteAnalyticsIpAddress]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsPageview] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsPageView_uMarketingSuiteAnalyticsPage]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsPageview] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsPageView_uMarketingSuiteAnalyticsPage_Referrer]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsPageview] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsPageview_uMarketingSuiteAnalyticsSession]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsScrollDepth', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsScrollDepth] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsScrollDepth_uMarketingSuiteAnalyticsPageview_id]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsTimeOnPage', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsTimeOnPage] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsTimeOnPage_uMarketingSuiteAnalyticsPageview_id]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitorTypeBotVersion', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsVisitorTypeBotVersion] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsBotVersion_uMarketingSuiteAnalyticsBot]
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsVisitorTypeBotVersion] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsVisitorTypeBotVersion_uMarketingSuiteAnalyticsVisitor]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitorTypeMonitor', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsVisitorTypeMonitor] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsVisitorTypeMonitor_uMarketingSuiteAnalyticsVisitor]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitorTypeSpam', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsVisitorTypeSpam] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsVisitorTypeSpam_uMarketingSuiteAnalyticsVisitor]
END IF OBJECT_ID('uMarketingSuitePersonalizationReferralGroupCustomerJourneyScoring', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuitePersonalizationReferralGroupCustomerJourneyScoring] DROP CONSTRAINT [FK_uMarketingSuitePersonalizationReferralGroupJourneyScoring_uMarketingSuitePersonalizationCustomerJourneyStep]
ALTER TABLE [dbo].[uMarketingSuitePersonalizationReferralGroupCustomerJourneyScoring] DROP CONSTRAINT [FK_uMarketingSuitePersonalizationReferralGroupJourneyScoring_uMarketingSuitePersonalizationReferralGroup]
END
IF OBJECT_ID('uMarketingSuitePersonalizationPersona', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuitePersonalizationPersona] DROP CONSTRAINT [FK_uMarketingSuitePersonalizationPersona_uMarketingSuitePersonalizationPersonaGroup]
END
IF OBJECT_ID('uMarketingSuitePersonalizationCustomerJourneyStep', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuitePersonalizationCustomerJourneyStep] DROP CONSTRAINT [FK_uMarketingSuitePersonalizationCustomerJourneyStep_uMarketingSuitePersonalizationCustomerJourneyGroup]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsSearchQuery', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsSearchQuery] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsSearchQuery_uMarketingSuiteAnalyticsPageview]
END
IF OBJECT_ID('uMarketingSuiteAnalyticsPageview', 'U') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[uMarketingSuiteAnalyticsPageview] DROP CONSTRAINT [FK_uMarketingSuiteAnalyticsPageview_uMarketingSuiteAnalyticsUmbracoPageVariant]
END
- And then drop all tables (sometimes you have to execute this twice to drop them all)
-- Drop tables
IF OBJECT_ID('uMarketingSuiteLock', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteLock]
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestUmbracoPageVariant', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAbTestingAbTestUmbracoPageVariant]
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestVariant', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAbTestingAbTestVariant]
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestVisitorToVariant', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAbTestingAbTestVisitorToVariant]
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestContentType', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAbTestingAbTestContentType]
IF OBJECT_ID('uMarketingSuiteAbTestingAbTest', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAbTestingAbTest]
IF OBJECT_ID('uMarketingSuiteAbTestingAbTestProject', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAbTestingAbTestProject]
IF OBJECT_ID('uMarketingSuiteAnalyticsAnnotationPageVariant', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsAnnotationPageVariant]
IF OBJECT_ID('uMarketingSuiteAnalyticsIpFilterIpAddress', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsIpFilterIpAddress]
IF OBJECT_ID('uMarketingSuiteAnalyticsIpFilter', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsIpFilter]
IF OBJECT_ID('uMarketingSuiteAnalyticsAnnotation', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsAnnotation]
IF OBJECT_ID('uMarketingSuiteAnalyticsSession', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsSession]IF OBJECT_ID('uMarketingSuiteAnalyticsBrowserVersion', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsBrowserVersion]
IF OBJECT_ID('uMarketingSuiteAnalyticsBrowser', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsBrowser]
IF OBJECT_ID('uMarketingSuiteAnalyticsCustomerJourneyPhase', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsCustomerJourneyPhase]
IF OBJECT_ID('uMarketingSuiteAnalyticsDevice', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsDevice]
IF OBJECT_ID('uMarketingSuiteAnalyticsGoalCompletion', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsGoalCompletion]
IF OBJECT_ID('uMarketingSuiteAnalyticsGoal', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsGoal]
IF OBJECT_ID('uMarketingSuiteAnalyticsIpCity', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsIpCity]
IF OBJECT_ID('uMarketingSuiteAnalyticsIpCounty', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsIpCounty]
IF OBJECT_ID('uMarketingSuiteAnalyticsIpCountry', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsIpCountry]
IF OBJECT_ID('uMarketingSuiteAnalyticsIpLocation', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsIpLocation]
IF OBJECT_ID('uMarketingSuiteAnalyticsIpProvince', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsIpProvince]
IF OBJECT_ID('uMarketingSuiteAnalyticsIpAddress', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsIpAddress]
IF OBJECT_ID('uMarketingSuiteAnalyticsLinks', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsLinks]
IF OBJECT_ID('uMarketingSuiteAnalyticsOperatingSystem', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsOperatingSystem]
IF OBJECT_ID('uMarketingSuiteAnalyticsOperatingSystemVersion', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsOperatingSystemVersion]
IF OBJECT_ID('uMarketingSuiteAnalyticsPageEvent', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsPageEvent]
IF OBJECT_ID('uMarketingSuiteAnalyticsPageView', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsPageView]
IF OBJECT_ID('uMarketingSuiteAnalyticsPersonalizationProfile', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsPersonalizationProfile]
IF OBJECT_ID('uMarketingSuiteAnalyticsPersonalizationPersona', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsPersonalizationPersona]
IF OBJECT_ID('uMarketingSuiteAnalyticsScreen', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsScreen]
IF OBJECT_ID('uMarketingSuiteAnalyticsScrollDepth', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsScrollDepth]
IF OBJECT_ID('uMarketingSuiteAnalyticsSearchEngine', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsSearchEngine]
IF OBJECT_ID('uMarketingSuiteAnalyticsTimeOnPage', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsTimeOnPage]
IF OBJECT_ID('uMarketingSuiteAnalyticsUmbracoPageVariant', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsUmbracoPageVariant]
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitorTypeMonitor', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsVisitorTypeMonitor]
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitor', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsVisitor]
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitorTypeBot', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsVisitorTypeBot]
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitorTypeBotVersion', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsVisitorTypeBotVersion]
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitorTypeSpam', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsVisitorTypeSpam]
IF OBJECT_ID('uMarketingSuitePersonalizationAppliedPersonalizationContentType', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationAppliedPersonalizationContentType]
IF OBJECT_ID('uMarketingSuitePersonalizationAppliedPersonalizationUmbracoPageVariant', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationAppliedPersonalizationUmbracoPageVariant]
IF OBJECT_ID('uMarketingSuitePersonalizationAppliedPersonalization', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationAppliedPersonalization]
IF OBJECT_ID('uMarketingSuitePersonalizationContentScoringCustomerJourneyStep', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationContentScoringCustomerJourneyStep]
IF OBJECT_ID('uMarketingSuitePersonalizationContentScoringPersona', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationContentScoringPersona]
IF OBJECT_ID('uMarketingSuitePersonalizationCustomerJourneyGroup', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationCustomerJourneyGroup]
IF OBJECT_ID('uMarketingSuitePersonalizationCustomerJourneyStep', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationCustomerJourneyStep]
IF OBJECT_ID('uMarketingSuiteAnalyticsVisitorTypeSpam', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationReferralGroupCustomerJourneyScoring]
IF OBJECT_ID('uMarketingSuitePersonalizationReferralGroupPage', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationReferralGroupPage]
IF OBJECT_ID('uMarketingSuitePersonalizationReferralGroupPersonaScoring', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationReferralGroupPersonaScoring]
IF OBJECT_ID('uMarketingSuitePersonalizationPersonaGroup', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationPersonaGroup]
IF OBJECT_ID('uMarketingSuitePersonalizationReferralGroup', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationReferralGroup]
IF OBJECT_ID('uMarketingSuitePersonalizationSegmentRule', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationSegmentRule]
IF OBJECT_ID('uMarketingSuitePersonalizationSegment', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationSegment]
IF OBJECT_ID('uMarketingSuiteAnalyticsSearchQuery', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsSearchQuery]
IF OBJECT_ID('uMarketingSuitePersonalizationReferralGroupCustomerJourneyScoring', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationReferralGroupCustomerJourneyScoring]
IF OBJECT_ID('uMarketingSuiteAnalyticsPage', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsPage]
IF OBJECT_ID('uMarketingSuitePersonalizationPersona', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuitePersonalizationPersona]
-- Delete the migration
DELETE [umbracoKeyValue]
where [key] = 'Umbraco.Core.Upgrader.State+uMarketingSuite'
-- Delete the uMarketingSection for each Umbraco user
DELETE FROM [umbracoUserGroup2App]
WHERE app = 'uMarketingSuite'
-- Delete all segment data that was inserted by the uMarketingSuite
DELETE FROM [umbracoPropertyData]
WHERE segment LIKE '%umarketingsuite%'
-- Update all document types and properties to not support variants anymore
UPDATE cmsContentType SET variations = 0 WHERE variations = 2
UPDATE cmsPropertyType SET variations = 0 WHERE variations = 2
- Run this SQL Script to remove the rawdata-tables. (This is a seperate script of the previous because it could make sense to leave all the raw data in the database and at a later moment process this data again.)
IF OBJECT_ID('uMarketingSuiteAnalyticsRawClientSideData', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsRawClientSideData]
IF OBJECT_ID('uMarketingSuiteAnalyticsRawPageview', 'U') IS NOT NULL
DROP TABLE [dbo].[uMarketingSuiteAnalyticsRawPageview]