Skip to content

Latest commit

 

History

History
361 lines (292 loc) · 13.9 KB

sql-server-dacpac-deployment-v1.md

File metadata and controls

361 lines (292 loc) · 13.9 KB
Raw
title description ms.date monikerRange
SqlServerDacpacDeployment@1 - SQL Server database deploy (Deprecated) v1 task
Deploy a SQL Server database using DACPAC.
06/11/2024
<=azure-pipelines

SqlServerDacpacDeployment@1 - SQL Server database deploy (Deprecated) v1 task

:::moniker range="=azure-pipelines"

Use this task to deploy a SQL Server database using DACPAC.

Important

[!INCLUDE task-deprecation] Use IIS Web App Deployment Using WinRM - Viual Studio Marketplace.

:::moniker-end

:::moniker range="<=azure-pipelines-2022.2"

Use this task to deploy a SQL Server database using DACPAC.

This task is deprecated.

:::moniker-end

Syntax

:::moniker range=">=azure-pipelines-2019.1"

# SQL Server database deploy (Deprecated) v1
# Deploy a SQL Server database using DACPAC.
- task: SqlServerDacpacDeployment@1
  inputs:
    EnvironmentName: # string. Required. Machines. 
    #AdminUserName: # string. Admin Login. 
    #AdminPassword: # string. Password. 
    #Protocol: # 'Http' | 'Https'. Protocol. 
    #TestCertificate: true # boolean. Optional. Use when Protocol = Https. Test Certificate. Default: true.
  # Deployment
    DacpacFile: # string. Required. DACPAC File. 
  # Target
    TargetMethod: 'server' # 'server' | 'connectionString' | 'publishProfile'. Required. Specify SQL Using. Default: server.
    ServerName: 'localhost' # string. Required when TargetMethod = server. Server Name. Default: localhost.
    DatabaseName: # string. Required when TargetMethod = server. Database Name. 
    #SqlUsername: # string. Optional. Use when TargetMethod = server. SQL Username. 
    #SqlPassword: # string. Optional. Use when TargetMethod = server. SQL Password. 
    #ConnectionString: # string. Required when TargetMethod = connectionString. Connection String. 
    #PublishProfile: # string. Publish Profile. 
    #AdditionalArguments: # string. Additional Arguments. 
  # Advanced
    #DeployInParallel: true # boolean. Deploy in Parallel. Default: true.
    #ResourceFilteringMethod: 'machineNames' # 'machineNames' | 'tags'. Select Machines By. Default: machineNames.
    #MachineFilter: # string. Deploy to Machines.

:::moniker-end

:::moniker range="=azure-pipelines-2019"

# SQL Server database deploy (Deprecated) v1
# Deploy SQL Server Database using DACPAC.
- task: SqlServerDacpacDeployment@1
  inputs:
    EnvironmentName: # string. Required. Machines. 
    #AdminUserName: # string. Admin Login. 
    #AdminPassword: # string. Password. 
    #Protocol: # 'Http' | 'Https'. Protocol. 
    #TestCertificate: true # boolean. Optional. Use when Protocol = Https. Test Certificate. Default: true.
  # Deployment
    DacpacFile: # string. Required. DACPAC File. 
  # Target
    TargetMethod: 'server' # 'server' | 'connectionString' | 'publishProfile'. Required. Specify SQL Using. Default: server.
    ServerName: 'localhost' # string. Required when TargetMethod = server. Server Name. Default: localhost.
    DatabaseName: # string. Required when TargetMethod = server. Database Name. 
    #SqlUsername: # string. Optional. Use when TargetMethod = server. SQL Username. 
    #SqlPassword: # string. Optional. Use when TargetMethod = server. SQL Password. 
    #ConnectionString: # string. Required when TargetMethod = connectionString. Connection String. 
    #PublishProfile: # string. Publish Profile. 
    #AdditionalArguments: # string. Additional Arguments. 
  # Advanced
    #DeployInParallel: true # boolean. Deploy in Parallel. Default: true.
    #ResourceFilteringMethod: 'machineNames' # 'machineNames' | 'tags'. Select Machines By. Default: machineNames.
    #MachineFilter: # string. Deploy to Machines.

:::moniker-end

Inputs

:::moniker range="<=azure-pipelines"

EnvironmentName - Machines
string. Required.

Specifies a comma-separated list of machine IP addresses or FQDNs along with ports. The default port is based on the selected protocol. For example: dbserver.fabrikam.com,dbserver_int.fabrikam.com:5986,192.168.12.34:5986 Output variables of other tasks can also be provided, for example $(variableName).


:::moniker-end

:::moniker range="<=azure-pipelines"

AdminUserName - Admin Login
string.

Specifies the administrator login for the target machines.


:::moniker-end

:::moniker range="<=azure-pipelines"

AdminPassword - Password
string.

Specifies the administrator password for the target machines. Variables defined in build or release definitions are accepted as $(passwordVariable). You can mark the variable type as secret to secure it.


:::moniker-end

:::moniker range="<=azure-pipelines"

Protocol - Protocol
string. Allowed values: Http, Https.

Specifies the protocol to use for the WinRM connection with the machine(s). The default value is HTTPS.


:::moniker-end

:::moniker range="<=azure-pipelines"

TestCertificate - Test Certificate
boolean. Optional. Use when Protocol = Https. Default value: true.

Skips the authenticity validation of the machine's certificate by a trusted certification authority. The parameter is required for the WinRM HTTPS protocol.


:::moniker-end

:::moniker range="<=azure-pipelines"

DacpacFile - DACPAC File
string. Required.

Specifies the location of the DACPAC file on the target machines or on a UNC path, like \\BudgetIT\Web\Deploy\FabrikamDB.dacpac. The UNC path should be accessible to the machine's administrator account. Environment variables are also supported, like $env:windir, $env:systemroot, and $env:windir\FabrikamFibre\Web.


:::moniker-end

:::moniker range="<=azure-pipelines"

TargetMethod - Specify SQL Using
string. Required. Allowed values: server, connectionString (Connection String), publishProfile (Publish Profile). Default value: server.

Specifies the option to connect to the target SQL Server database. You can provide SQL Server database details, a SQL Server connection string, or a publish profile XML file.


:::moniker-end

:::moniker range="<=azure-pipelines"

ServerName - Server Name
string. Required when TargetMethod = server. Default value: localhost.

Specifies the SQL Server name, like machinename\FabriakmSQL,1433 or localhost or .\SQL2012R2. Specifying localhost connects to the default SQL Server instance on the machine.


:::moniker-end

:::moniker range="<=azure-pipelines"

DatabaseName - Database Name
string. Required when TargetMethod = server.

Specifies the name of the SQL Server database.


:::moniker-end

:::moniker range="<=azure-pipelines"

SqlUsername - SQL Username
string. Optional. Use when TargetMethod = server.

If the SQL Server login is specified, it is used to connect to the SQL Server. The default, Integrated Authentication, uses the machine administrator's credentials.


:::moniker-end

:::moniker range="<=azure-pipelines"

SqlPassword - SQL Password
string. Optional. Use when TargetMethod = server.

If the SQL Server login user name is specified, provide the SQL Server password. The default, Integrated Authentication, uses the machine administrator's credentials.


:::moniker-end

:::moniker range="<=azure-pipelines"

ConnectionString - Connection String
string. Required when TargetMethod = connectionString.

Specifies the SQL Server connection string, like Server=localhost;Database=Fabrikam;User ID=AccountPlaceholder;Password=PasswordPlaceholder;.


:::moniker-end

:::moniker range="<=azure-pipelines"

PublishProfile - Publish Profile
string.

Provides fine-grained control over SQL Server database creation or upgrades. Specifies the path to the publish profile XML file on the target machine or on a UNC share that is accessible by the machine administrator's credentials.


:::moniker-end

:::moniker range="<=azure-pipelines"

AdditionalArguments - Additional Arguments
string.

Specifies additional SqlPackage.exe arguments that are applied when creating or updating the SQL Server database, like /p:IgnoreAnsiNulls=True or /p:IgnoreComments=True. These arguments will override the settings in the publish profile XML file (if provided).


:::moniker-end

:::moniker range="<=azure-pipelines"

DeployInParallel - Deploy in Parallel
boolean. Default value: true.

When set to true, runs the database deployment task in parallel on the target machines.


:::moniker-end

:::moniker range="<=azure-pipelines"

ResourceFilteringMethod - Select Machines By
string. Allowed values: machineNames (Machine Names), tags. Default value: machineNames.

Optional. Specifies a subset of machines by providing machine names or tags.


:::moniker-end

:::moniker range="<=azure-pipelines"

MachineFilter - Deploy to Machines
string.

This input is only valid for machine groups and is not supported for a flat list of machines or output variables yet.
Specifies a list of machines, like dbserver.fabrikam.com, webserver.fabrikam.com, 192.168.12.34, or tags, like Role:DB; OS:Win8.1. If multiple tags are provided, the task runs in all machines with the specified tags. For Azure Resource Groups, provide the virtual machine's name, like ffweb or ffdb. The default runs the task in all machines.


:::moniker-end

Task control options

All tasks have control options in addition to their task inputs. For more information, see Control options and common task properties.

Output variables

:::moniker range="<=azure-pipelines"

None.

:::moniker-end

Requirements

:::moniker range="<=azure-pipelines"

Requirement Description
Pipeline types YAML, Classic build, Classic release
Runs on Agent, DeploymentGroup
Demands None
Capabilities This task does not satisfy any demands for subsequent tasks in the job.
Command restrictions Any
Settable variables Any
Agent version 1.96.2 or greater
Task category Deploy

:::moniker-end