Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Overview of this book

Table of Contents (18 chapters)
Microsoft SQL Server 2008 R2 Master Data Services
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Summary


Now that we have finished the chapter, a summary of what we have covered is as follows:

  • Versions are an integral part of MDS and are useful for maintaining separate copies of master data, for archiving, what-if, or testing purposes.

  • A version can have one of the following statuses:

    • Open—Users can edit members within the version according to their Security permissions.

    • Locked—Only Administrative users can edit data within the version. A version can be unlocked, in which case it will return to a status of Open.

    • Committed—The version data will be permanently read-only for all users and cannot be reversed.

  • We can create a new version by copying an old version.

  • Validation causes the MDS Business Rules to fire, which will result in the members of a version being marked as valid or invalid, which will impact how external applications interact with the master data.

  • Flags can be useful to provide an indicator to versions, which can help provide information to systems that get fed from MDS.

  • As in...