Share via

How to implement Automated deployment of MDS

Rohit 241 Reputation points
2021-03-18T14:35:05.063+00:00

We have a requirement wherein we want to set up a deployment model for master data services.
Is there any automated way yo achieve it ?

SQL Server Other
Accepted answer
  1. Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator
    2021-03-19T04:56:29.547+00:00

    Hey ,
    As mentioned by @AmeliaGu-MSFT , you can leverage the MDS deploy commands and automated based on Self hosted agent for automated deployment.

    Below link would help :

    https://datasharkx.wordpress.com/2021/03/18/automated-deployment-of-master-data-service-mds-through-azure-devops/

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    2021-03-19T02:34:01.493+00:00

    Hi @Rohit ,
    You can launch windows command prompt to use MDSModelDeploy tool to create and deploy model objects and data. By default, the MDSModelDeploy.exe is available at drive:\Program Files\Microsoft SQL Server\nnn\Master Data Services\Configuration. (nnn=150 for MDS 2019, nnn=140 for MDS 2017 and so on)

    Please refer to the following articles which might help:
    Deploying Models
    How to Deploy Master Data Services Models

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.