How to version a SQL Server Master Data Services model

By:   |   Comments   |   Related: > Master Data Services


In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen and marked as ready for subscribers. Until a model is marked as ready, a model is typically deemed as work in progress. A standard process is required to release a completed version of the model to subscribers, which we will cover in this tip.


In this tip we will look at how to version and flag a model in SQL Server Master Data Services (MDS). A typical workflow of version management in MDS is as mentioned below:

  1. An initial version of the model is created when a new model is created and populated in MDS. This is an uncommitted version of the model.
  2. Once the model is ready, the model is generally locked by the administrator from any further changes.
  3. Business rules are then validated on the locked version of the data and post validation the model is committed.
  4. Now changes cannot be made to the committed version. This version is then flagged for use by subscribers.

So let's see how to implement this. We will assume that we have a model already in place.

Open Master Data Manager and navigate to "Version Management". Select the version and lock the model as shown in the below screenshot. Once locked the status of the model will show as "Locked".

SQL Server Master Data Services Locked version of the model

Once locked, the end users will not be able to make any changes to the version. They will see the members in the entities with a locked icon as shown in the below screenshot. So you may want to let the users know that this version has been locked from any changes. Admins would still be able to make changes to this version if needed.

SQL Server Master Data Services lock version of all attributes

Click on the Validate Version menu item, and this should bring up a screen as shown below. If you have business rules defined, you can click on the Validate button to validate the model against the business rules. The below screenshot shows that all the entities have been validated successfully. Click on the Commit button to save this version.

SQL Server Master Data Services Commit version of the model

Once the version is committed successfully, you will see a confirmation message and the Commit button will be disabled.

Successful Commit of SQL Server Master Data Services Model

Now that the version is successfully committed, we need to flag the version which the subscribers can use to detect this version as ready for use. In order to create a new flag, click on the Manage menu item and select Flags. Click on the Add button and create a new flag as shown below.

Manage version flags in SQL Server Master Data Services

Navigate back to Manage > Versions, and double click on the Flag field of the model as shown below. You will be able to see the list of flags available. Select the newly created flag and let the subscribers know. This completes the version management workflow.

Assign Flag for the SQL Server Master Data Services Model
Next Steps

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

get free sql tips
agree to terms