title: Could not load file or assembly Microsoft.SqlServer.TransactSql
body: <p>Database project build failed.  Error Details: </p>
  
  <blockquote>
    <p>Error:  MSB4018: The "SqlBuildTask" task failed unexpectedly.
        System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.TransactSql, Version=12.0.0.0, Culture=neutral,
    PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The
    system cannot find the file specified.
        File name: 'Microsoft.SqlServer.TransactSql, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'</p>
  </blockquote>
  
  <p>I also go through this answer on stackoverflow <a href="https://stackoverflow.com/questions/22891270/database-project-deploy-fails-in-visual-studio-2013">link</a>. Also Download SQL Server Data Tools 12.0.41012.0, but still facing this error. Need assistance to build database so that I may publish my Database on Azure. </p>
  
  <p>Regards.</p>