| title | Model Deployment Package Examples | ||
|---|---|---|---|
| description | SQL Server Examples: Model Deployment Packages (MDS) | ||
| author | meetdeepak | ||
| ms.author | dkhare | ||
| ms.reviewer | mikeray | ||
| ms.date | 03/05/2026 | ||
| ms.service | sql | ||
| ms.subservice | master-data-services | ||
| ms.topic | sample | ||
| ms.custom |
|
||
| keywords |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
[!INCLUDE support-notice]
Sample model packages with data are included when you install [!INCLUDEssMDSshort]. The default location for these package files is <drive>\Program Files\Microsoft SQL Server\130\Master Data Services\Samples\Packages.
For instructions on how to deploy the sample model packages, see Deploying Sample Models and Data. You deploy the sample model packages by using the MDSModelDeploy tool.
Important
Sample Updates in [!INCLUDEssnoversion]
The sample packages support the following capabilities.
-
Show Many-to-Many Relationships.
For more information, see M2M Relationship in Sample Model.
-
Constrain Allowed Values for Domain-based Attributes.
For more information, see Create a Domain-Based Attribute (Master Data Services).
-
Require Approval for Entity Changes.
For more information, see Approval Required (Master Data Services).
-
Use Not and Else Operators in Business Rules
For more information, see Business Rule Examples.
-
Implement Custom Index
For more information, see Custom Index (Master Data Services).
In Master Data Services, a package is an XML file that contains a deployable model structure, and optionally, data from the model. Use model packages to move copies of models from one MDS environment to another, or to create new models in your existing [!INCLUDEssMDSshort] environment.