How to create database with .sql file in visual studio 2010

Question

I downloaded a asp.net webform application off the internet and it included a .sql file to create the database and tables. I'm new to asp.net/visual studio and kind of stuck with this for days now. Need help.

here's the content of the web.config

<configuration>
<connectionStrings>
    <add name="MyConsString" connectionString="Data Source=localhost\SQLEXPRESS; Initial Catalog=myslideshow; Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
    <compilation debug="true" targetFramework="4.0"/>
<httpRuntime executionTimeout="240" maxRequestLength="10240000" />
</system.web>

open the .sql file in sql server and press f5 or press execute button in window authentication — Ram Singh
– Ram Singh, Commented Jan 14, 2013 at 11:52

ZedBee · Accepted Answer · 2013-01-14 11:50:07Z

2

Open the file with .sql extension in visual studio
Right Click
Execute script

answered Jan 14, 2013 at 11:50

ZedBee

2,3687 gold badges40 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AKxox Over a year ago

No option to execute script

Nick N. · Accepted Answer · 2013-04-18 07:11:17Z

0

Open the SQL file
use CTRL-SHIFT-E

answered Apr 18, 2013 at 7:11

Nick N.

13.7k9 gold badges62 silver badges77 bronze badges

Collectives™ on Stack Overflow

How to create database with .sql file in visual studio 2010

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related