Skip to content

sqlpackage-pipelines.md

Latest commit

 

History

History
51 lines (36 loc) · 2.35 KB

sqlpackage-pipelines.md

File metadata and controls

51 lines (36 loc) · 2.35 KB
title SqlPackage in development pipelines
description Learn how to troubleshoot database development pipelines with SqlPackage.exe by checking the installed build number.
ms.prod sql
ms.prod_service sql-tools
ms.technology tools-other
ms.topic conceptual
ms.assetid 198198e2-7cf4-4a21-bda4-51b36cb4284b
author dzsquared
ms.author drskwier
ms.reviewer maghan; sstein
ms.date 11/4/2020

SqlPackage in development pipelines

SqlPackage.exe is a command-line utility that automates several database development tasks and can be incorporated into CI/CD pipelines.

Managed virtual environments

The virtual environments used for GitHub Actions hosted runners and Azure Pipelines VM images are managed in the virtual-environments GitHub repository. SqlPackage is included in the windows-latest environment and updates to the images are made within a few weeks of each SqlPackage release.

Checking the SqlPackage version

During troubleshooting efforts, it is important to know the SqlPackage version in use. Capturing this information can be done by adding a step to the pipeline to run SqlPackage with the /version parameter. Examples are given below based on the Microsoft and GitHub managed environments, self-hosted environments may have different installation paths for the working directory.

Azure Pipelines

By leveraging the script keyword in an Azure Pipeline, a step can be added to an Azure Pipeline that outputs the SqlPackage version number.

- script: sqlpackage.exe /version
  workingDirectory: C:\Program Files\Microsoft SQL Server\150\DAC\bin\
  displayName: 'get sqlpackage version'

GitHub Actions

By leveraging the run keyword in a GitHub Action workflow, a step can be added to a GitHub Action that outputs the SqlPackage version number.

- name: get sqlpackage version
  working-directory: C:\Program Files\Microsoft SQL Server\150\DAC\bin\
  run: ./sqlpackage.exe /version

:::image type="content" source="media/sqlpackage-pipelines-github-action.png" alt-text="GitHub action output displaying build number 15.0.4897.1":::

Next steps