Reputation: 939
I have migrated a database project from VS2008 to VS2010. While in VS08, I used to be able to right-click on a .sql or .cmd file and select a "Run" or "Run On" command from the context menu.
In VS2010, though, these menu items seem to have gone away.
I have a number of .sql and .cmd scripts that I am used to being able to run directly from the Visual Studio IDE.
Can someone point me in the right direction?
Thanks, Steve
Upvotes: 3
Views: 515
Reputation: 11
Open the sql source you want to execute. Now, right click in the editor and select "Execute SQL". First time you will be asked to connect to a database. If you want to execute on a second database you have to right click and select "Connection->Disconnect" first.
Upvotes: 1
Reputation: 5165
Unfortunately they have not been implemented (much to the annoyance of developers)
MS say:
Unfortunately we were unable to add the right click on database reference/server explorer conx to the product.
More details at:
http://social.msdn.microsoft.com/Forums/en/vstsdb/thread/f374c604-a7eb-496d-a261-9374790cdbf9
Upvotes: 0