I added localdb to my project and am trying to add tables to it. But I could not see the "Add table" item in the menu, there are only "Update" and "Properties" items. According to Microsoft, SSDT comes preloaded with VS2015, but there is no way to add a new table. Did I miss something?
I added localdb to my project and am trying to add tables to it. But I could not see the item "Add table" in the menu, there is only "Refresh" and "Properties".
To fix the problem:
Go to Control Panel and try to restore the software.
Do not forget to restart the machine.
Instead of using Server Browser, use View → SQL Server Object Browser.
Alternatively, you can create an SSDT project, add your tables to the project, and then deploy, which would be the right way to do it! Ed
Even hard I did the repair and rebooted, but I wouldn’t get "Add a new table", I checked that "Microsoft SQL Server Data Tools" was selected for installation (change, change).
I solved the problem by installing the latest version of "Microsoft SQL Server Data Tools" separately. https://msdn.microsoft.com/en-us/library/mt204009.aspx • Download the SSDT product release for Visual Studio 2012 (link) I installed the package and rebooted the computer. I opened the project, and I managed to select "Add a new table" :-)