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

Creating and managing versions


There is no button to create a version in MDS. Instead, a version may only be created by copying another version.

Tip

Version configuration settings

By default it is only possible to copy a version once it has been committed. This may be fine for some implementations, but prevents you from running two open versions side-by-side. Thankfully, there is a configuration setting that overrides this behavior. The setting is called Copy Only Committed Versions and can be accessed via the MDS Configuration Manager.

Copying a version

The process of copying a version quite simply takes all the members that exist within the source version and copies them into the new version. The supporting structures that the copied members require, such as entities, attributes, attribute groups, derived hierarchies, and collections are all made available to the new version.

Regardless of the status of the source version, the new version that gets created will have a status of open.

In our...