How to create database with SQL express bundled with Visual Studio?
Yes, Visual studio comes bundled with a copy of SQL express edition which gets installed during visual studio installation.
These steps are required to create database with SQL express bundled with Visual Studio. So guys, I request you all to please perform these steps while reading this article.
-
- View Server Explorer
-
- Add a Server
-
- Server Details
-
- Create Database
-
- Database details
-
- Choose Add Connection
-
- Add Connection
-
- Connection Properties
Click on at least one image to start the slideshow
Refer Slide 1,To view the SQL express,Click on ‘View’ -> ‘Server Explorer’.
Refer Slide 2, Right Click on ‘Servers’ and select ‘Add a Server’.
Refer Slide 3, Write Server Name in the Dialog, In this case, you have to write your machine name.
Refer Slide 4,To create a database,Right Click on Data Connections and select “Create SQL server database”.
Refer Slide 5, In the dialog box, select server name from the list, select the authentication you want to use and provide a new database name.
Refer Slide 6, To create a connection,Right Click on Data Connections and select “Add Connection”.
Refer Slide 7,In “Choose Data Source” dialog box, select “Microsoft SQL Server”, data provider will get filled simultaneously.Click continue.
Refer Slide 8, Fill Connection properties in the dialog box, select server name from the list. Once server is selected, “Connect to database” section gets activated, select database and click “Test Connection”.
Comments awaited!
