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.

  1. Open visual studio.
  2. Go to tools menu and click on Extensions and Updates.
  3. Under the updates you will find an update for database proj.
  4. By clicking it, it will download an exe.
  5. When you run the exe it will ask for Repair/UnInstall.
  6. Click repair and proceed.