AzureDevOpsExtensionsForSqlServer
AzureDevOpsExtensionsForSqlServer copied to clipboard
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.