The Manager_Schema_DeleteAll.sql script removes all data from the Unica Platform system tables without removing the tables themselves. This script removes all users, groups, security credentials, data filters, and configuration settings from Unica 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 Unica Platform.

Additional requirements

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

  • Run 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.
  • 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.