MSDeploy -setParam option is replacing `"""` with` "&quot"` in the connection string

Question

When deploying app with msdeploy, i am changing connection string with option -setparam, this is changing connection string but replacing " with &quot;

i have tried using "^" , it didn't work, if i use "^"" i am getting "^&quot;"

"C:\Program Files\IIS\Microsoft Web Deploy V3\msDeploy.exe"  -verb:sync -source:package="package.zip" -dest:auto -setParamFile="SetParameters.xml" -setParam:name="IIS Web Application Name",value="VALUE" -setParam:name="XXXX-Web.config Connection String",value="metadata=res://*/XXXXXXX|res://*/XXXXXXXX|res://*/XXXXXXXXX;provider=System.Data.SqlClient;provider connection string=&quot;data source=XXXXXXX;initial catalog=XXXXX;Integrated Security=SSPI;Persist Security Info=false;Trusted_Connection=Yes;multipleactiveresultsets=True;App=EntityFramework&quot;"

""" at end and in middle is getting replaced with "&quot;"

That is disrupting connection to DB, i don't why it is appending "&amp" to "&", its basically making &quot: to &quot: — chandra, Apr 09 '19 at 20:14

score 1 · Answer 1 · answered Apr 10 '19 at 16:52

1

MS deploy -setParam option will replace """ with "&&quot" in the connection strings, to counter that i had to replace """ with single quotes ' in the connection string

answered Apr 10 '19 at 16:52

chandra

693
3
8
21

MSDeploy -setParam option is replacing `"""` with` "&quot"` in the connection string

1 Answers1