...
The SQL Package Extract action creates a database snapshot (.dacpac) file from a live SQL Server or Azure SQL Database.
SQL Package Extract
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. [/SourceServerName]
...
The timeout for establishing a connection to the database in seconds. Leave blank to use the default of 15 seconds. [/SourceTimeout]
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
...