...
The SQL Server/Azure connection string to connect to the database. [/TargetConnectionString]
An example of a valid connection string is:
...
The name of the server that hosts the database. The server should be accessible by the agent running the action. [/TargetServerName]
Database Name
The name of the source database. [/TargetDatabaseName]
Authentication Type
The authentication method. Either by using a Username and Password or Windows Authentication.
...
The name of the user who has permissions to perform the operation on the database. [/TargetUser]
Password
The password for the user connecting to the database. [/TargetPassword]
Windows Authentication
If this is selected, windows authentication is used to gain permission to perform the operation on the database.
...
If this is ticked, SQL encryption is used. [/TargetEncryptConnection]
Trust server certificate
If this is ticked, SSL certificate validation is bypassed. [/TargetEncryptConnection]
Connection Timeout
The timeout for establishing a connection to the database in seconds. Leave blank to use the default of 15 seconds. [/TargetTimeout]
Variables
Variables
Specify one variable per line in the format of variable_name=variable_value. [/Variables:]
...
Specifies the amount of information to display in the build log. [/Quiet | /Diagnostics]
Command Timeout
The command timeout in seconds when executing queries against SQL Server. Leave blank to use the default of 30 seconds. [/p:CommandTimeout=]
Max Parallelism
Degree of parallelism for concurrent operations running against a database. [/MaxParallelism]
Additional Arguments
Any extra command-line parameters for SQLPackage.exe. The full list of extra arguments can be found at SqlPackage.exe.
...