Removing all data (ManagerSchema

Removing all data (ManagerSchema_DeleteAll.sql)

The Manager_Schema_DeleteAll.sql script removes all data from the Marketing Platform system tables without removing the tables themselves. This script removes all users, groups, security credentials, data filters, and configuration settings from the Marketing Platform.

When to use ManagerSchema_DeleteAll.sql

You might want to use ManagerSchema_DeleteAll.sql if corrupted data prevents you from using an instance of the Marketing Platform.

Additional requirements

To make the Marketing Platform operational after running ManagerSchema_DeleteAll.sql , you must perform the following steps.

Run the populateDB utility as described in The populateDb utility. The populateDB utility restores the default configuration properties, users, roles, and groups, but does not restore any users, roles, and groups you have created or imported after initial installation.

Use the configTool utility with the config_navigation.xml file to import menu items, as described in The configTool utility.

If you have performed any post-installation configuration, such as creating data filters or integrating with an LDAP server or web access control platform, you must perform these configurations again.

If you want to restore previously existing data filters, run the datafilteringScriptTool utility using the XML originally created to specify the data filters.