question

DataArtist avatar image
0 Votes"
DataArtist asked DataArtist answered

Unable to deploy MDS Sample package in SQL SERVER 2019 MDS

![138248-image.png][1]


Unable to deploy MDS Sample package - Customer_en.pkg and I m getting the following error which says it contains data.

Also I have tried deploying using the command line using the below command

MDSModelDeploy deploynew -package "C:\Program Files\Microsoft SQL Server\150\Master Data Services\Samples\Packages\customer_en.pkg" -service MDS Dev

Command line error :

C:\Program Files\Microsoft SQL Server\150\Master Data Services\Configuration>MDSModelDeploy deploynew -package "C:\Program Files\Microsoft SQL Server\150\Master Data Services\Samples\Packages\customer_en.pkg" -service MDS Dev

MDSModelDeploy operation failed. Elapsed time: 00:00:00.0211941
Error:
The DeployNew command failed because either there is a missing - option or the name is not in quotes. All names that contain spaces must be enclosed in quotation marks.

As you can see below MDS Dev is a service listed :

C:\Program Files\Microsoft SQL Server\150\Master Data Services\Configuration>MDSModelDeploy listservices
MDS services (Service, Website, Virtual Path):
MDS1, MDS,
MDS2, MDS Dev,

MDSModelDeploy operation completed successfully. Elapsed time: 00:00:00.0317065

C:\Program Files\Microsoft SQL Server\150\Master Data Services\Configuration>


Using Windows 10 , Chrome and SQL SERVER 2019 MDS .


![138327-image.png][2]

Sample packages:
[1]: /answers/storage/attachments/138248-image.png
[2]: /answers/storage/attachments/138327-image.png

sql-server-generalsql-server-integration-services
image.png (25.3 KiB)
image.png (54.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DataArtist,

As the error message mentioned, did the package also contains data?

Use the Master Data Manager model deployment wizard to deploy packages that contain model objects only. If you need to deploy a package with data, see Deploy a Model Deployment Package by Using MDSModelDeploy.


1 Vote 1 ·

Thanks , I was able to deploy . It appears commands are case sensitive

C:\Program Files\Microsoft SQL Server\150\Master Data Services\Configuration>MDSModelDeploy deploynew -package Customer_en.pkg -model Customer -service MDS1
Deploying package Customer_en.pkg using new model name Customer

MDSModelDeploy operation completed successfully. Elapsed time: 00:00:35.1414327

0 Votes 0 ·

1 Answer

DataArtist avatar image
0 Votes"
DataArtist answered

C:\Program Files\Microsoft SQL Server\150\Master Data Services\Configuration>MDSModelDeploy deploynew -package Customer_en.pkg -model Customer -service MDS1
Deploying package Customer_en.pkg using new model name Customer

MDSModelDeploy operation completed successfully. Elapsed time: 00:00:35.1414327

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.