#title Master Data Service
[[TableOfContents]]


==== Master Data service ====
 * [Master Data service 설치]

'''sample 설치'''
cd "C:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration"

MDSModelDeploy.exe deploynew  -package "C:\Program Files\Microsoft SQL Server\110\Master Data Services\Samples\Packages\Packages\customer_en.pkg" -model CustomerSample -service MDS1 

MDSModelDeploy.exe deploynew  -package "C:\Program Files\Microsoft SQL Server\110\Master Data Services\Samples\Packages\chartofaccounts_en.pkg" -model ChartOfAccountsSample -service MDS1 

MDSModelDeploy.exe deploynew  -package "C:\Program Files\Microsoft SQL Server\110\Master Data Services\Samples\Packages\product_en.pkg" -model ProductsSample -service MDS1 

{{{
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\dwa>cd "C:\Program Files\Microsoft SQL Server\110\Master Data Services
Configuration"

C:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration>MD
ModelDeploy.exe deploynew -package "C:\Program Files\Microsoft SQL Server\110\M
ster Data Services\Samples\Packages\customer_en.pkg" -model CustomerSample -ser
ice MDS1
새 모델 이름 CustomerSample을(를) 사용하여 C:\Program Files\Microsoft SQL Serve
\110\Master Data Services\Samples\Packages\customer_en.pkg 패키지 배포

MDSModelDeploy 작업에 실패했습니다. 경과된 시간: 00:00:02.3452806
오류:
'C:\Program Files\Microsoft SQL Server\110\Master Data Services\Samples\Package
\customer_en.pkg' 경로에 대한 액세스가 거부되었습니다.
}}}
이런 경우는 
 1. MDSModelDeploy.exe 마우스 오른 클릭 -> 속성
 1. 호환성 탭 클릭
 1. '관리자 권한으로 이 프로그램 실행'에 체크
==== 참고자료 ====
 * [http://www.microsoft.com/downloads/ko-kr/details.aspx?familyid=901c315f-37ac-423c-aaa9-06da9d061286&displaylang=ko Microsoft® Excel®용 Microsoft® SQL Server® 2012 Master Data Services 추가 기능]
 * http://nickbarclay.blogspot.com/search/label/Master%20Data%20Services
 * mdm 사이트에서 실버라이트 설치 후 에러 뜨면 iis에서 익명사용자 enable 시키면 된다. 
 * [http://www.google.co.kr/#q=master+data+service&hl=ko&newwindow=1&prmd=ivnsul&source=univ&tbm=vid&tbo=u&sa=X&ei=4vZZTpC-MYLXrQeatqCMCw&ved=0CH4Q7Qk&bav=on.2,or.r_gc.r_pw.&fp=eb60c29f04d42731&biw=1920&bih=965 MDS Video1]
 * [http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=155 MDS Video2]
 * [http://sqlblog.com/blogs/mds_team/archive/2011/01/11/new-master-data-services-training-available.aspx New Master Data Services Training Available]
 * [http://sqlblog.com/blogs/mds_team/default.aspx Master Data Services Team]
 * [http://www.databasejournal.com/features/mssql/article.php/3906361/How-to-Import-Browse-And-Export-Master-Data-Services-Data.htm How to Import, Browse And Export Master Data Services' Data]
 * [http://www.databasejournal.com/features/mssql/article.php/3904846/article.htm Creating Master Data Services Objects]
 * [http://www.databasejournal.com/features/mssql/article.php/3903081/article.htm Getting started with SQL Server 2008 R2's Master Data Services]
 * [http://www.databasejournal.com/features/mssql/article.php/3898626/article.htm An Overview of SQL Server Master Data Services]
 * [http://www.mssqltips.com/tip.asp?tip=2030&home Introduction to Master Data Services in SQL Server 2008]
 * [http://www.microsoft.com/sqlserver/2008/en/us/mds.aspx SQL Server 2008 R2 Master Data Services]
 * [http://msdn.microsoft.com/en-us/library/bb190163.aspx The What, Why, and How of Master Data Management]
 * [http://searchcio.techtarget.com/news/article/0,289142,sid182_gci1197441,00.html Seven master data management best practices]
 * [http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=155 An Introduction to SQL Server 2008 R2 Master Data Services]

==== 관련 사이트 ====
 * http://sqlblog.com/blogs/mds_team/