We have some build tasks that run and for the life of me I can't figure out why the ms build tools isn't installing the master.dacpac file needed for the master and system dacpac files.
Here's where it lives now:
C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\Extensions\Microsoft\SQLDB\Extensions\SqlServer\150\SQLSchemas
Currently, in VS2019 Professional it is added with the Data Storage and Processing Workload. SQL Server Data Tools is a dependency for several other workloads, such as:
- ASP.NET and web development
- ASP.NET and web development tools
- Azure Data Lake and Stream Analytics Tools
- Cloud tools for web development
In MS Build Tools, I noticed that the dacpac file isn't generated after installing the Data Tools workload.
Am I looking in the wrong place? What is generating the master.dacpac and the system.dacpac in C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\Extensions\Microsoft\SQLDB\Extensions\SqlServer\150\SQLSchemas?
