Edit a Model Deployment Package

Applies to: SQL Server - Windows only Azure SQL Managed Instance

This topic describes how to deploy selected parts of a model in MDS, rather than an entire model. To do so, you edit an MDS model package using the Model Package Editor.

The Model Package Editor wizard enables you to select the specific entities, derived hierarchies, subscription views, and business rules in a model that you want to include in an MDS package, and then later deploy. You can leave out those parts of the model that you do not want to deploy. When you select an entity, all of the dependent objects in that entity are also automatically selected.

You use the Model Package Editor to select parts of a model in a package file that was created by either the MDSModelDeploy tool (which creates a package file that includes objects and data) or the Model Deployment wizard (which creates a file that includes only the model structure). After editing the model in the package, you use the MDSModelDeploy tool to deploy objects and data, or the Model Deployment wizard to deploy just the model structure.

Prerequisites

To perform this procedure:

To edit a model deployment package

  1. In Windows Explorer on the MDS server, move to drive:\Program Files\Microsoft SQL Server\130\Master Data Services\Configuration.

  2. Execute ModelPackageEditor.exe.

  3. In the Model Package Editor wizard, click Browse, move to the folder containing your packages, select a package, and then click Open. Click Next.

  4. Select those entities, derived hierarchies, subscriptions views, or business rules that you want to deploy. Deselect those that you do not want to deploy. Click Next.

  5. Verify the list of selections to deploy. To change, click Back and repeat step 4.

  6. Click Browse, move to the folder that you want to save the partial package in, and then enter the file name of the partial package (with a .pkg extension). Click Save.

  7. Click Finish.

Next Steps