Deploying to SQL SERVER 2016 from source control

This is a quick blog to help others avoid what I went through
while trying to deploy a DB from TFS to SQL Server 2016 with no success.

Apart from the usual option of backup/restore there was no other
viable way of deploying through source control. Visual Studio would throw an
“unable to connect to target server” error despite the connection being
successfully tested.

In mid-dec 2015 Microsoft released an update to Visual
Studio 2015 Data Services (link) where it made possible to deploy to SQL SERVER