edit-and-delete-an-entity-sync-relationship-master-data-services.md

title	Edit and Delete an Entity Sync Relationship
description	Edit and Delete an Entity Sync Relationship (Master Data Services)
author	meetdeepak
ms.author	dkhare
ms.reviewer	mikeray
ms.date	03/05/2026
ms.service	sql
ms.subservice	master-data-services
ms.topic	how-to
ms.custom	build-2025

Edit and Delete an Entity Sync Relationship (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

Entity sync is a one-way and repeatable synchronization between entity versions. It provides a way to share entity data between different models. You can edit and delete a sync relationship that you've created.

Prerequisites

Prerequisites to edit an entity sync relationship.

• You must have permission to access the System Administration functional area. For more information, see Functional Area Permissions (Master Data Services).

• You must be a model administrator of the target model. For more information, see Administrators (Master Data Services).

• You must have at least read access to the source entity and all its attributes and members.

Prerequisites to delete an entity sync relationship.

• You must have permission to access the System Administration functional area. For more information, see Functional Area Permissions (Master Data Services).

• You must be a model administrator of the target model. For more information, see Administrators (Master Data Services).

Consider the following when editing an entity sync relationship.

• The source and target entities must be in different models.

• A target entity version status must not be committed.

• Once a sync relationship has been established, the target is immediately synced with the source.

• A target entity version cannot be a source entity version of another sync relationship.

Consider the following when executing an entity sync relationship

• Only leaf members will be copied.

• Domain-based attributes will not be copied.

• Soft-deleted members will not be copied.

• Sync does not generate target entity transactions/histories.

To edit an entity sync relationship

1. In Master Data Manager, click System Administration.

2. On the Model View page, from the menu bar, point to Manage and click Entity Sync.

3. On the Entity Sync Maintenance page, select a sync relationship in the grid.

4. Click Edit. A panel shows up on the right side.

5. Change Frequency. Select Sync On Demand, or select Auto Sync and set a frequency.

6. Click Save.

To delete an entity sync relationship

1. In Master Data Manager, click System Administration.

2. On the Model View page, from the menu bar, point to Manage and click Entity Sync.

3. On the Entity Sync Maintenance page, select a sync relationship in the grid.

4. Click Delete.

5. In the confirmation dialog, click OK.

See Also

Create and Execute an Entity Sync Relationship (Master Data Services)
Entity Sync Relationship (Master Data Services)