Skip to content

Latest commit

 

History

History
115 lines (69 loc) · 6.14 KB

deploy-a-model-deployment-package-by-using-mdsmodeldeploy.md

File metadata and controls

115 lines (69 loc) · 6.14 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Deploy a Model Deployment Package (MDSModelDeploy)
Learn how to use MDSModelDeploy to deploy a package in Master Data Services. A package can contain either model objects only or model objects and data.
CordeliaGrey
jiwang6
03/14/2017
sql
master-data-services
how-to
intro-deployment

Deploy a Model Deployment Package by Using MDSModelDeploy

[!INCLUDE SQL Server - Windows only ASDBMI]

In [!INCLUDEssMDSshort], use the MDSModelDeploy tool to deploy a package that contains either:

  • Model objects only.

  • Model objects and data.

If you want to deploy a package that contains model objects only, you can use the model deployment wizard in the [!INCLUDEssMDSmdm] web application instead. For more information, see Deploy a Model Deployment Package by Using the Wizard.

Important

Packages can be deployed to the edition of [!INCLUDEssNoVersion] they were created in only. This means that packages created in [!INCLUDEssSQL11] cannot be deployed to [!INCLUDEssSQL14] or higher.

Prerequisites

To perform this procedure:

To deploy a model deployment package

  1. Determine whether you are deploying a new model, a clone of a model, or updating a previously-cloned model. For more information, see Model Deployment Options (Master Data Services).

  2. Open an Administrator: Command Prompt and navigate to MDSModelDeploy.exe.

    • If MDS is installed at the default location, the tool is available at drive:\Program Files\Microsoft SQL Server\130\Master Data Services\Configuration

    • If MDS is not installed at the default location, search the local computer for MDSModelDeploy.exe.

  3. Optional. View options and help.

    • To display all available options, type MDSModelDeploy and press Enter.

    • To display help for an option, type the following, where OptionName is the name of the option: MDSModelDeploy help OptionName.

  4. Optional. If you have multiple web applications, determine the name of the service you will deploy to by typing this command and pressing Enter:

    MDSModelDeploy listservices

    A list of values is returned, for example MDS1, Default Web Site, MDS. The first value in this list (in this case, MDS1) is needed to deploy the model.

  5. Depending on whether you are creating a model, cloning a model, or updating a model, at the command prompt, type the following and press Enter.

    • To create a new model:

      MDSModelDeploy deploynew -package PackageName -model ModelName -service ServiceName

    • To create a clone of a model:

      MDSModelDeploy deployclone -package PackageName

    • To update an existing model and its data:

      MDSModelDeploy deployupdate -package PackageName -version VersionName

    [!IMPORTANT]
    If you use the MDSModelDeploy tool to update an existing model and its data, and the package does not contain an entity, attribute, or member that exists in the destination model, MDSModelDeploy will not delete that entity, attribute, or member from the model.

    Where PackageName is the name of the package (.pkg) file, ModelName is the name of the new model, VersionName is the name of the version, and ServiceName is the name of the service that you returned in the previous step. Ensure that the model and version names match the exact case-sensitive names.

  6. When the package is successfully deployed, a message stating "MDSModelDeploy operation completed successfully" is displayed.

Notes:

  • If a subscription view in the package has the same name as a subscription view in an existing model, this warning is displayed: Deployer subscription view renamed and the view is created as modelname.subscriptionviewname. If this name is already in use, the subscription view is not created.

  • The deployment process has four steps:

    1. The model objects are created.

    2. Business rules are created.

    3. Subscription views are created.

    4. Master data is populated.

  • When creating a new or cloned model, if the process fails during any step, the model is deleted.

    When updating a model, if the process fails during the first three steps, it does not proceed; however, changes that are already made are not rolled back. If the process fails in step 4, members that can be updated are updated.

Next Steps

File attributes, and user and group permissions are not included in model deployment packages. After you deploy a model, you must update these manually. For more information, see:

See Also

Deploying Models (Master Data Services)