sqlpackage missing flags

Question

Hi
I using sqlpackage for publish, but I'm missing the below flags which I used to work with earlier:

Integrated Security  
Persist Security Info  
Pooling  
MultipleActiveResultSets  

I don't see them in the documentation:
https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-publish?view=sql-server-ver15#parameters-for-the-publish-action

Any idea why they are not there?
More info based on the answers below:
I've forgot to mention it in the question, but when I used the below syntax (using powershell):

$sqlpackage = Start-Process -FilePath sqlpackage.exe -ArgumentList '/Action:Publish','/SourceFile:"Database Services\bin\Release\Database Services.dacpac"',"/p:TargetConnectionString:""Data Source=${Env};Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;Initial catalog=${Target}""" -wait -PassThru -Credential $Cred  
$sqlpackage.WaitForExit()  
$sqlpackage  

I got this exception:

*** 'TargetConnectionString:Data Source' is not a valid argument for the 'Publish' action.  

So I ended up with this command (which is missing the flags I've mentioned above):

$sqlpackage = Start-Process -FilePath sqlpackage.exe -ArgumentList '/Action:Publish','/SourceFile:"Database Services\bin\Release\Database Services.dacpac"',"/TargetServerName:${Env}","/TargetDatabaseName:${Target}",'/p:BlockOnPossibleDataLoss=True' -wait -PassThru -Credential $Cred  
$sqlpackage.WaitForExit()  
$sqlpackage  

Answer 1

Hi arielman2304-0180,
Sorry that I am not familiar with PowerShell.
Could you please try to change /p:TargetConnectionString: to /TargetConnectionString: in your command?

$sqlpackage = Start-Process -FilePath sqlpackage.exe -ArgumentList '/Action:Publish','/SourceFile:"Database Services\bin\Release\Database Services.dacpac"',"/p:TargetConnectionString:""Data Source=${Env};Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;Initial catalog=${Target}""" -wait -PassThru -Credential $Cred
$sqlpackage.WaitForExit()
$sqlpackage

Best Regards,
Amelia

Answer 2

Hi arielman2304-0180,

As Tom mentioned, the flags are connection string options.
Please refer to the following docs to view the connection string we can use:
Connection String Keywords with OLE DB Driver
DSN and Connection String Keywords

Best Regards,
Amelia

---

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.

Answer 3

Those are connection string options, not sqlpackage options.

You can specify connection string options by using SourceConnectionString and TargetConnectionString parameter.