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 ?
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 :
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)
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
11 people are following this question.