Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Designing and deploying framework to use Master Data Services


The Master Data Services (MDS) helps to solve the problem of storing, integrating, and enforcing processes. This helps to decide which data we want to manage, build a model and rules for, load data and establish workflows and notifications. In this recipe, we will go through the process of designing and deploying a framework to use MDS effectively, that includes deploying a package of a model to a target MDS environment.

Getting ready

The prerequisites for this recipe are as follows:

  • Ensure that the account used to perform the procedure has permission to access the System Administration functional area in the target MDS environment

  • Ensure that a model deployment package exists. We can create a package of a model from the source system and deploy it directly to another MDS environment; use the package to create a new model or update an existing model

For this recipe, we will use the sample package files that are included when installing...