-
Notifications
You must be signed in to change notification settings - Fork 15
Build Server Setup
Azure Pipelines provides access to a range of Microsoft-hosted agents. These can be used to build your SQL Server projects, which gives you some faith in the quality of your software. However, these hosted agents can only deploy to Azure-hosted services such as Azure SQL Database and Azure Analysis Services. SSIS and SSRS projects are left out in the cold.
To effectively work with on-premise SQL Server instances, you need an in-house build server with the Azure Pipelines self-hosted agent installed.
How to install the agent is well documented by Microsoft, so will not be repeated here. However, we recommend the following:
Create a Virtual Machine Install Visual Studio 2017
DevOps your Data Warehouse
Import into SSDT
- Import Databases
- Fixing Database Import Issues
- Import SSAS Projects
- Import SSIS Projects
- Import SSRS Projects
Build
- Basic Build Pipeline
- Basic Overview
- Build Databases
- Build Tabular Cubes
- Build Multidimensional Cubes
- Build SSIS Projects
- Build SSRS Projects
Deployment
- Build Server Setup
- Build/Deploy Pipeline
- Deploy Databases
- Deploy Tabular Cubes
- Deploy SSIS Projects
- Deploy SSRS Projects
Unit Tests
Integration Tests
Packaging Artifacts
Deployment Tools