Visual Studio 2013 SQL Query and View Designer does not appear

Question

Not sure why query and view designer doesn't show as

http://msdn.microsoft.com/en-us/library/vstudio/ms172013.aspx

This is an ASP.net project with a database in the AppData folder and a connection using SQL 2008 Express.

If this helps the connection string:

Data Source =. \ SQLEXPRESS; AttachDbFilename = "C: \ folders ... \ App_Data \ database.mdf"; Integrated Security = True; Connection timeout = 30; User Instance = True

If I open a project in VS2012 (where I worked on this project for some time), find the table, right-click, new request, I will get a good interactive visual design tool.

If I open the project in VS2013 (just installed) and do the same, a blank page with the name SQLQuery1.sql and a basic connection to SQL Express (i.e. wizard, model, etc.)

The MS page tells me Tools / Options / Visual Database Tools - but it does not exist during my installation!

Did I miss something?

We also tried with an empty project, added App_Data and a new database (using LocalDB), added a table, right-click, the new query is the exact same empty file.

Answer 1

I have the same problem and I think I found a solution.

When you add a connection to the database in the Add Connection dialog box. Click "Edit ..." next to the data source.

A dialog opens showing "Change Data Source"

You probably chose "Microsoft SQL Server" and then below, where you can choose:

.NET Framework Data Provider for OLE DB
.NET Framework Data Provider for SQL Server (this may be selected by default)

try switching to an OLE DB connection.

Click OK, and then fill out the remaining connection in the Add Connection dialog box. Then I discovered that using the database works the same way as in VS2012, and as you describe above.

Answer 2

Looking for a solution to a similar problem. Cannot use query designer for local database of mdf files. This is what I found ... hope this helps someone.

Read comments here ( http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ed4675d3-aa84-47db-bdf5-f852355409e6/query-designer-not-displaying-in-visual-studio-2013? forum = ssdt ).

According to the moderator of this question on the forum (Kevin Kunnan of Microsoft), "In Visual Studio 2013, the query designer and database chart functions are no longer available in the server browser. If you want to continue to use the query designer, only another workaround at the moment is access to him from SSMS. "

My current workaround is to use Visual Studio 2012 Server Explorer to view data and record requests for a local MDF file. And use Visual Studio 2013 for everything else.

Answer 3

Despite the fact that I followed the same steps, it did not work right away, and it gave some error, and Studio closed. It was a problem at my end and, unconsciously, it figured out on its own.

Answer 4

This component is called SQL Server Data Tools. You can download it from MSDN . I found this page just googling "vs2013 ssdt". It seems that the published TsugaSoft is true, however you can still install this component in different ways ... And it also works for Visual Studio 2012.

Answer 5

I explored for about 5 minutes how to execute a query in Visual Studio. In the end, I found this: