SQL Server 2012- Deploying Master Data Services 2012 sample packages using MDSMODELDEPLOY.exe

Hi Friends,

When you install Master Data Services 2012, you can deploy sample packages that come with the installation. The sample packages are located in C:\Program Files\Microsoft SQL Server\110\Master Data Services\Samples\Packages

To install the packages, use mdsmodeldeploy.exe which is located in C:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration

Sample command to deploy:

C:\Program Files\Microsoft SQL Server\110\Master Data Services\Configuration>mdsmodeldeploy deploynew -package “C:\Program Files\Microsoft SQL Server\110\Master Data Services\Samples\Packages\chartofaccounts_en.pkg” -model “Chart of Accounts”

The mdsmodeldeploy tool deploys the object model as well as the data, unlike the Model Deployment Wizard.


Once all the 3 sample packages are deployed, you should be able to browse them in MDS web app:



About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published.