Change Tracking (Master Data Services)

Applies to: SQL Server on Windows Azure SQL Managed Instance

Important

Master Data Services (MDS) is removed in SQL Server 2025 (17.x). We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.

In Master Data Services, you can use change tracking groups to take action when an attribute value changes. Use change tracking when you don't know what the new value will be, but instead want to know if any change occurred.

Configuring Change Tracking

To configure change tracking, you add an attribute to a change tracking group. The group can contain one or many attributes. Then, you create a business rule to define the action that is taken when any of the attributes in the group change.

Note

Change tracking business rules consider staged (imported) data to be changed.

Related Tasks

Task Description	Topic
Add attributes to a change tracking group.	Add Attributes to a Change Tracking Group (Master Data Services)
Create a business rule that initiates actions based on attribute changes.	Initiate Actions Based on Attribute Value Changes (Master Data Services)

Related Content

• Validation (Master Data Services)

• Business Rules (Master Data Services)

• Attributes (Master Data Services)