AzureDevOpsExtensionsForSqlServer
AzureDevOpsExtensionsForSqlServer copied to clipboard
Published
20 hours ago •
DrJohnT
DrJohnT
Microsoft SQL Server deployment extensions for Azure DevOps Pipelines
Azure DevOps Extensions for SQL Server
This repo contains several extensions for Azure DevOps that help in deploying a wide variety of Microsoft SQL Server components such as Analysis Services tabular cubes, SQL Server databases and Integration Services projects.
Azure DevOps Exensions
| Azure DevOps Extension | Description and Project Link | Build |
|---|---|---|
 |
Deploys a SQL Server Database DACPAC to a server using a DAC Publish Profile | |
 |
Deploy, update and drop a tabular cube model on Microsoft SQL Server Analysis Services (SSAS) | |
 |
Run single or multiple SQLCMD Scripts passing multiple SQLCMD variables |
The associated project wiki explains the basics of applying DevOps to your Data Warehouse and outlines exactly how to setup your in-house build server, Azure Pipelines and test suites.
Note that the Publish DACPAC using a DAC Publish Profile extension is also published as Deploy Database DACPAC using a DAC Publish Profile using the same codebase as most people thing Deploy rather than Publish.
DrJohnT