Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server - Windows only
Azure SQL Managed Instance
Important
Master Data Services (MDS) is removed in SQL Server 2025 (17.x) Preview. We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.
Master Data Services now supports the ability to save any pending changes to an entity as changesets. There are two usage scenarios for this feature.
Changes when "Approval Required" is turned on by Entity Administrator
If an Entity administrator specifies that the changes to a given entity require approval before they are committed, any changes to the entity have to be saved into a new or an existing changeset before they can be submitted for approval. For more information, see Approval Required (Master Data Services)
You would follow this workflow.
You create a changeset. The changeset is in the Open state. See Create a Changeset (Master Data Services)
You apply the changeset and add some changes to the changeset. See Apply and Update a Changeset (Master Data Services)
You submit the changeset to the entity administrator for approval. The changeset is in the Pending state. See Commit or Submit a Changeset (Master Data Services)
The entity administrator gets an email notification that a changeset is waiting for approval. If the entity administrator approves the changeset, the changeset is in the Approved state. See Approve or Reject a Changeset (Master Data Services)
The approved changeset will be committed automatically. If the change is committed successfully, the changeset is in the committed state.
Local User changes
If you merely want to save your local changes so you can use or retrieve them later, you can use changesets to achieve that.
You would follow this workflow.
You create a changeset. The changeset is in the Open state. See Create a Changeset (Master Data Services)
You apply the changeset and add some changes to the changeset. See Apply and Update a Changeset (Master Data Services)
When ready, you commit the changeset. See Commit or Submit a Changeset (Master Data Services)
See Also
Create a Changeset (Master Data Services)
Apply and Update a Changeset (Master Data Services)
Commit or Submit a Changeset (Master Data Services)
Approve or Reject a Changeset (Master Data Services)
Manage Changesets (Master Data Services)