Versions (Master Data Services)
Applies To: SQL Server 2016 Preview
In Master Data Services, you can create multiple versions of the master data within a model. Versions can be locked while you validate your data and committed after the data is validated. Committed versions form an auditable record of changes. Each version you create contains all members, attribute values, hierarchy members, hierarchy relationships, and collections for the model.
Use versions to:
Maintain an auditable record of your master data as it changes over time.
Prevent users from making changes while you ensure all data validates successfully against business rules.
Lock down a model for use by subscribing systems.
Test different hierarchies without implementing them right away.
When you change the structure of your model, such as when you create a new entity or domain-based attribute, the change applies to all versions. If you view an earlier version of the model, the entity or attribute is displayed, but no data exists.
When a version is ready for users or for a subscribing system, you can set a flag to identify the version. You can move this flag from version to version as needed. Flags help users and subscribing systems identify which version of a model to use.
Use the following workflow for version management:
An initial version is created automatically when you create a model and populate the Master Data Services database with your company's master data. Based on permissions, users can make changes to this version as needed.
When you want to commit a version of a model, lock the version so that only model administrators can update the data. For more information, see Administrators (Master Data Services). If notifications are configured, an email notification is sent to model administrators each time the version's status changes. For more information, see Configure Email Notifications (Master Data Services).
Apply business rules to the locked version's data and review any validation issues. If necessary, you can fill in missing information or revert the transaction that caused the issue. You can also unlock the version for users to make changes.
When all the data passes validation, commit the version and flag it for use by subscribing systems. Changes cannot be made to a committed version.
Copy the committed version and notify users that they can begin working in a new version of the model.
You can create sequential or simultaneous versions of your model.
Sequential versions. Each time you commit a version, create a new copy and give the version the next sequential number. For example, you can copy Version 7 of your model and name the copy Version 8.
Simultaneous versions. Create simultaneous versions of your model when you want to work on two or more versions of your data at once. This is useful when your company has reorganizations or mergers that coincide with the normal course of business and you want to determine how the new master data might fit into your existing structures.
A setting in Master Data Services Configuration Manager determines whether or not you can copy all versions or only those that are committed. To create simultaneous versions you must configure Master Data Services to allow you to copy all versions. This setting is also available in the System Settings table. For more information, see System Settings (Master Data Services).
Change the name of an existing version.
Lock a version so only administrators can edit its data.
Unlock a version so users can edit its data.
Commit a version after all data is validated.
Create a new flag to mark a version.
Change the name of an existing version flag.
Assign an existing flag to a version.
Create a new copy of an existing version
Delete an existing version.
Purge soft-deleted members from a version