...
The SQL Package Export action exports a live database from SQL Server or Azure SQL Database to a BACPAC package (.bacpac file). By default, data for all tables will be included in the .bacpac file. Optionally, you can specify only a subset of tables for which to export data. Validation for the Export action ensures Azure SQL Database compatibility for the complete targeted database even if a subset of tables is specified for the export.
SQL Package Export
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
...