Purge Version Members (Master Data Services)

Applies to: SQL Server - Windows only Azure SQL Managed Instance

In Master Data Services, deleting a member only deactivates, or soft-deletes, it. The data still resides in the database. This topic describes how to purge (permanently delete) all soft-deleted members in a model version.

Prerequisites

To perform this procedure.

To purge soft-deleted members

  1. In Master Data Manager, click Version Management.

  2. On the Manage Versions page, select the model that has the version that you want to purge. The list of model versions is displayed.

  3. Select the row for the version that you want to purge.

  4. Click Purge Members.

  5. Click "OK" on the confirmation prompt.

Additional Methods to Purge Members

Purging version members permanently delete soft-deleted members in all entities pertaining to the selected version. A more finely grained alternative is to use entity base staging to permanently delete only specific members of an entity. Also, entity administrators with Explorer functional permission may purge an entity version in the entity explorer page.

For more information, see Leaf Member Staging Table (Master Data Services)