Run SQL script inside Visual Studio

Question

I have a scripted database SQL file that I need to execute inside Visual Studio to create a new database. I am so far unable to locate any function that allows me to do this.

Answer 1

Go to server explorer in VS, right click on server and select run query.

Do you mind telling us why it has to be run inside VS?

In addition, the database projects offers a lot of features that are worth looking at:

http://www.informit.com/articles/article.aspx?p=31764 //old article but still worth reading.

http://www.ssw.com.au/ssw/standards/BetterSoftwareSuggestions/Images/VisualStudio_DataDude_SchemaCompare.gif

http://www.emadibrahim.com/2008/07/10/database-schema-compare-upgrade/

Answer 2

There is a green arrow of play on the upper left corner of the window query. And down the tabs of the names of open files in VS. Just click to play and ready.