Failed to load Microsoft.SqlServer.TransactSql file or assembly.

Database project failed. Error Details:

Error: MSB4018: The SqlBuildTask task terminated 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 specified file. File name:" Microsoft.SqlServer.TransactSql, Version = 12.0.0.0, Culture = Neutral, PublicKeyToken = 89845dcd8080cc91 '

I will also review this answer on the stackoverflow link. Also download SQL Server Data Tools 12.0.41012.0, but still run into this error. Need help creating a database so I can publish my database to Azure.

Sincerely.

+5
source share
2 answers

Uncheck "Enable advanced ...". It will be removed in the next version of VS. (Click the "More Information" link next to it.)

enter image description here

+16
source

It happened to me and just fixed. I update ssdt from the link that I get from the Visual studio notification center and restart VS as administrator, then it works fine. -Janak

+4
source

Source: https://habr.com/ru/post/1213223/


All Articles