How to implement Automated deployment of MDS

Rohit 226 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,666 questions
Accepted answer
  1. Nandan Hegde 29,886 Reputation points MVP
    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 13,961 Reputation points Microsoft Vendor
    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