Last post Aug 24, 2012 04:14 PM by lestat0109
Aug 20, 2012 07:26 AM|lestat0109|LINK
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.
Aug 22, 2012 03:19 AM|Kenon-YGN|LINK
Installing SQL Server Data Tools（SSDT）is recommended. I think that tool will help you a lot!
Here is the download address:http://msdn.microsoft.com/en-us/data/hh297027
Hope my suggestion will do help for you.
Aug 24, 2012 04:14 PM|lestat0109|LINK
I am seeing in other forums that SSDT is incompatible with VS 2012 for web because it requires the VS 2010 shell. Should this be considered a confirmed bug? It does not work the way it should and apparently everyone else is just happy doing it some other
way. Works fine using LocalDB with an automatic instance, but when pointing your instance to a local instance of SQL Server (SQLEXPRESS) you lose the ability to edit the database (.mdf) from within the IDE.
I have now done multiple clean installs using seperate laptops and still the same results. I would be more than thrilled to be proven wrong here but otherwise
Microsoft should consider this a confirmed bug.