This question already has an answer here:
Closed 7 years ago.
Possible Duplicate:
Getting Sql Server Data Tools to work with Visual Studio 2012 Express Release Candidate
I have installed VS 2012 for Web and SQL Server 2012 and am opening a solution built in VWD 2010 and SQL 2008. The application runs fine and I am able to add/edit/delete records using the application. However, when i go to database explorer and right click on a table, i do not get the "Show table data" option anymore. When I right click on the database i do not get the "Create table" option either. This is a .mdf file. I have tried connecting to another SQL server (not the one on my local machine) and i get all those options, same thing with a localdb. Any idea why i wouldnt be getting these options for an SQL server installed on my local machine? Pipes/Shared/TCP are all enabled. Please help.
I think such options will only be available for Sql Databases, not for Access databases.
Updated Answer
Then I would recommend you to go for Sql Server Management Studio, free tool from Microsoft to Explore Sql Server Database. More flexible than built VS Plugin. Can do a lots of stuffs from there.
Its quite bulky in download (615Mb). here id the FileHippo link Sql Management Studio 2012 Express
I am not sure about what version you have installed in your machine, whether its express or standard. If its express then it will definitely work with the above link. But before downloading make sure you have express edition installed. Also I guess, other edition might come bundled with the Management Studio. You can install from there too.
See this answer.
To summarize, SSDT and Visual Studio Express for Web are incompatible. You need to use the VS 2010 shell to use SSDT.
