Database Deployment - An Error Occurred During Deployment Plan Generation. Deployment Cannot Continue

I wondered if someone could perhaps help save my sanity by telling me what I'm missing here. The background first. We have 5 database projects in TC, each with a build step and the

Solution 1:

It looks as if your build server has a different version of sqlpackage (i.e. DacFX) than the one that Visual Studio is using, and only one of your five projects contains whatever feature is handled "differently" by the two versions.

There's a bit of detail in this msdn thread.

In short, I'd be updating DacFX on the build server, and making sure the build job is calling the sqlpackage.exe that is in

C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130

Solution 2:

In my case SQLCLR on .NET version was different in the project Properties. Thanks @Gavin for pointing on right direction. And corrected "Compatibility Level"