TeamCity/.sqlproj build via MSBuild -- FAILED

I found a blog post from Lukie Briner, his last paragraph pointed me to the solution (thank you buddy!).

Still don't know why/how this can happen, maybe it is related to the order of the installations of Build Tools, SSDT, Visual Studio etc.?

The reason: SSDT was missing in the Build Tools and its version of MSBuild.

What I have done:

Copy the SSDT folder from

C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\MSBuild\Microsoft\VisualStudio\v15.0

C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\MSBuild\Microsoft\VisualStudio\v15.0.

WOW! I finally see a REAL error message:

build-tools-msbuild-error-message

Now I had to copy SQLDB and SQLEditor (I think SQLCommon already existed in the destination folder, if not it should also be copied) from

C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\Extensions\Microsoft

C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\Common7\IDE\Extensions\Microsoft

and BOOM...

success

And yes, the VS2017 runner from TeamCity is also happy with it.

Related