Changesets (Master Data Services)

Applies to: SQL Server on Windows Azure SQL Managed Instance

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.

  1. You create a changeset. The changeset is in the Open state. See Create a Changeset (Master Data Services)

  2. You apply the changeset and add some changes to the changeset. See Apply and Update a Changeset (Master Data Services)

  3. 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)

  4. 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)

  5. 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.

  1. You create a changeset. The changeset is in the Open state. See Create a Changeset (Master Data Services)

  2. You apply the changeset and add some changes to the changeset. See Apply and Update a Changeset (Master Data Services)

  3. When ready, you commit the changeset. See Commit or Submit a Changeset (Master Data Services)

Related content

• 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)