What happened to the "Run" and "Run On" commands in Visual Studio 2010 Database Projects?
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?
开发者_StackOverflow中文版Thanks, Steve
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.
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
精彩评论