Skip to content

DrJohnT/AzureDevOpsExtensionsForSqlServer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Donate with PayPal to Dr John T

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
Publish DACPAC using a DAC Publish Profile Deploys a SQL Server Database DACPAC to a server using a DAC Publish Profile Build
Deployment tools for SSAS Tabular Cube Models Deploy, update and drop a tabular cube model on Microsoft SQL Server Analysis Services (SSAS) Build
Run SQL / SQLCMD Scripts passing multiple SQLCMD variables Run single or multiple SQLCMD Scripts passing multiple SQLCMD variables Build

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.