Go to uMarketingSuite on Github Go to uMarketingSuite on LinkedIn Go to uMarketingSuite on YouTube Go to uMarketingSuite.com Go to uMarketingSuite on Our Umbraco
  1. Home
  2. Installing uMarketingSuite
  3. Disabling / Uninstalling uMarketingSuite

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.

  1. Via the NuGet package manager



  2. 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:

  1. Delete all files in the following folders
    1. /App_Plugins/uMarketingSuite/*
    2. /Assets/uMarketingSuite/*
    3. /Config/uMarketingSuite/*
  2. Delete the following files in your /bin/-folder
    1. /bin/uMarketingSuite.Business.dll
    2. /bin/uMarketingSuite.Common.dll
    3. /bin/uMarketingSuite.Data.dll
    4. /bin/uMarketingSuite.Licensing.package.dll
    5. /bin/uMarketingSuite.Web.dll
  3. Delete the datatypes in the folder uMarketingSuite in the Settings section of your Umbraco installations
    1. uMarketingSuite - Node picker
    2. uMarketingSuite - Time input
    3. The uMarketingSuite folder
  4. Delete the folder uMarketingSuite and its contents in the Media section.
  5. 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
  6. 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
  7. 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]
Previous article
Next article