Error when calling SQLPackage 'publish' with TargetDatabaseName or tdn argument

Question

As the SQLPackage manual here when calling publish action, we have the argument TargetDatabaseName or tdn (in section Target Parameters)

But when adding this parameter to SQLPackage call, I got the error saying that the argument is not valid.

Example:

SQLPackage.exe 
  /a:Publish 
  /SourceFile:"Path\to\My\CompiledDbProjectFile.dacpac"       
  /TargetUser:"SomeLoginName"  
  /TargetPassword:"SomePassword" 
  /TargetServerName:"SomeSQLServerInstance" 
  /TargetDatabaseName="SomeDatabase" 
  /p:BlockOnPossibleDataLoss=true 
  /p:DropRoleMembersNotInSource=false 
  /p:DropPermissionsNotInSource=false 
  /p:DropObjectsNotInSource=false

Is that a bug? How can we work around for that?

Currently I have to use the /tcs:"The connections tring goes here"

Could you give an example of the arguments you are passing to SqlPackage? Note that arguments should look something like "SqlPackage.exe /a:publish /tdn:mydb /tsn:(localhost) /sf:myfile.dscpac". For overriding deployment properties you use the format "/p:CreateNewDatabase=true" — Kevin Cunnane, Dec 25 '13 at 14:01

score 3 · Accepted Answer · answered Dec 27 '13 at 09:53

3

This syntax is wrong

/TargetDatabaseName="SomeDatabase"

The correct one should be

/TargetDatabaseName:"SomeDatabase"

Cheers

answered Dec 27 '13 at 09:53

Nam G VU

33,193
69
233
372

Error when calling SQLPackage 'publish' with TargetDatabaseName or tdn argument

1 Answers1