Build Databases
Having your Azure Pipeline build your SSDT projects is simplicy itself. You simply add and configure the Microsoft MsBuild task to your Azure Pipeline as shown below:
Note that MsBuild 15.0 will build the following components in your Visual Studio solution (if present):
- SQL Server Database (SSDT) Projects
- Tabular cube projects targeting SQL Server Analysis Services (SSAS)
- SSRS projects
However, MsBuild does not currently build solutions that contain:
- SSIS projects
- Multidimensional cube projects
See Build SSIS Projects and Build Multidimensional Cubes for how to build these projects.
Note: we strongly recommend creating three Visual Studio solutions:
- One for all your database and SSDT unit test projects
- Another containing your tabular cube projects, and a
- Final project containing your SSIS project
Having SSIS projects in the same solution as SSDT database projects will cause MsBuild 15.0 to error. Surprisingly MsBuild 14.0 did not error, but ignored the SSIS project.
Although Tabular cube projects can coexist with SQL Server Database (SSDT) Projects, they have an annoying habit of opening the model every time the solution is built.