CODEWITHSUNDEEP
msbuildsql-server-data-tools
Rajesh
Rajesh

Reputation: 2502

How to deploy multiple database on Team build

I tried the following in MSBuild Arguments but this didn't work out.

/t:Build;Publish /p:SqlPublishProfilePath=McMData1.local.publish.xml 
/p:SqlPublishProfilePath McMData1.local.publish.xml

Upvotes: 1

Views: 1174

Answers (1)

SoftwareCarpenter
SoftwareCarpenter

Reputation: 3923

You can only specify one SqlPublishProfilePath value. You can create another msbuild command task to publish another database project separately or create another build definition.

Also, you could make the database properties inside the xml file command line driven , but you can still only specify one .xml file and have one deployment.

Upvotes: 3

Related Questions