VS2013 Database Project fails to build
I created a new SQL Server Database Project in VS2013 (Update 3) and attempted to build but it fails. The only build output I receive follows:
------ Build started: Project: Database1, Configuration: Debug Any CPU ------
Creating a model to represent the project...
Done building project "Database1.sqlproj" -- FAILED.
Build FAILED.
========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========
If I build the project via MSBuild.exe with detail verbosity I see the following inner failure:
Task "SqlBuildTask"
Creating a model to represent the project...
Done executing task "SqlBuildTask" -- FAILED.
After searching the web I have tried the following to resolve this to no avail:
-Restart VS
-Restart machine
-Repair VS Update 3 and reboot
-Repair VS2013 and reboot
What am I missing?
Solution 1:
After contacting a friend at Microsoft, he suggested repairing the Data Tools install at
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
And that resolved it.
Thanks Chuck!
Solution 2:
I had a similar issue and as mentioned in the accepted answer repairing is the solution. But unfortunately the link did not gave me an exe that says repair/UnInstall. I went ahead and run exe still issue persists.
I resolved it by updating the sql data tools using Extensions and Updates. Following are the steps.
- Open visual studio.
- Go to tools menu and click on Extensions and Updates.
- Under the updates you will find an update for database proj.
- By clicking it, it will download an exe.
- When you run the exe it will ask for Repair/UnInstall.
- Click repair and proceed.