1 Master Data service

2 참고자료

3 관련 사이트

• 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 마우스 오른 클릭 -> 속성
   
2. 호환성 탭 클릭
   
3. '관리자 권한으로 이 프로그램 실행'에 체크
   

• Microsoft® Excel®용 Microsoft® SQL Server® 2012 Master Data Services 추가 기능(http://www.microsoft.com/downloads/ko-kr/details.aspx?familyid=901c315f-37ac-423c-aaa9-06da9d061286&displaylang=ko)
  
• http://nickbarclay.blogspot.com/search/label/Master%20Data%20Services
  
• mdm 사이트에서 실버라이트 설치 후 에러 뜨면 iis에서 익명사용자 enable 시키면 된다.
  
• MDS Video1(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 Video2(http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=155)
  
• New Master Data Services Training Available(http://sqlblog.com/blogs/mds_team/archive/2011/01/11/new-master-data-services-training-available.aspx)
  
• Master Data Services Team(http://sqlblog.com/blogs/mds_team/default.aspx)
  
• How to Import, Browse And Export Master Data Services' Data(http://www.databasejournal.com/features/mssql/article.php/3906361/How-to-Import-Browse-And-Export-Master-Data-Services-Data.htm)
  
• Creating Master Data Services Objects(http://www.databasejournal.com/features/mssql/article.php/3904846/article.htm)
  
• Getting started with SQL Server 2008 R2's Master Data Services(http://www.databasejournal.com/features/mssql/article.php/3903081/article.htm)
  
• An Overview of SQL Server Master Data Services(http://www.databasejournal.com/features/mssql/article.php/3898626/article.htm)
  
• Introduction to Master Data Services in SQL Server 2008(http://www.mssqltips.com/tip.asp?tip=2030&home)
  
• SQL Server 2008 R2 Master Data Services(http://www.microsoft.com/sqlserver/2008/en/us/mds.aspx)
  
• The What, Why, and How of Master Data Management(http://msdn.microsoft.com/en-us/library/bb190163.aspx)
  
• Seven master data management best practices(http://searchcio.techtarget.com/news/article/0,289142,sid182_gci1197441,00.html)
  
• An Introduction to SQL Server 2008 R2 Master Data Services(http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=155)
  
  

• http://sqlblog.com/blogs/mds_team/