Get sqlcmd.exe in Azure Pipelines

pipelines.ps1

$ErrorActionPreference = 'Stop';

Invoke-WebRequest 'https://vstsagenttools.blob.core.windows.net/tools/SQLCMD/11.0/SQLCMD.zip' -OutFile sqlcmd.zip

try {
    Add-Type -AssemblyName System.IO.Compression.FileSystem
} catch { };

[System.IO.Compression.ZipFile]::ExtractToDirectory('./sqlcmd.zip', './')

$env:PATH += ";$(Resolve-Path ./SQLCMD)";

# sqlcmd.exe will now be in your PATH

References include:

• https://github.com/microsoft/azure-pipelines-tasks/blob/88b272b7c3bc4ec862f8dd79b4d20ecf0d740ab0/Tasks/SqlAzureDacpacDeploymentV1/make.json#L41
• https://github.com/microsoft/azure-pipelines-tasks/blob/88b272b7c3bc4ec862f8dd79b4d20ecf0d740ab0/make-util.js#L435-L440

This is more or less how https://github.com/microsoft/azure-pipelines-tasks/tree/master/Tasks/SqlAzureDacpacDeploymentV1 works.

Just add a PowerShell task and use this as an inline script prior to running sqlcmd.exe.

Note that it would still be preferable to use the SqlServer PowerShell Module as an alternative.