...
The SQL Package Publish action incrementally updates the schema of a target database to match the structure of a source database. Publishing a deployment package that contains user data for all or a subset of tables update the table data in addition to the schema. Data deployment overwrites the schema and data in existing tables of the target database. Data deployment will not change existing schema or data in the target database for tables not included in the deployment package.
SQL Package Publish
Name
A friendly name for this action (will be displayed in the actions workflow area).
...
Whether to use a connection string or specify each part of the connection separately.
Connection String
Connection String
...
Provider=SQLNCLI11;Password=myPassword;User ID=[username]@[servername];Initial Catalog=databasename;Data Source=tcp:[servername].database.windows.net;
Connection Properties
Server Name
The name of the server that hosts the database. The server should be accessible by the agent running the action. [/TargetServerName]
...
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:]
Properties
Properties
Specify one property per line in the format of property_name=property_value. The full list of properties can be found at SqlPackage.exe. [/p:]
Options
Logging Verbosity
...