How to create a database project using visual studio 2017?

Hi Readers,

In this article, You are going to learn how to create a database project using visual studio 2017

Most of us know creating a database using SSMS (SQL SERVER MANAGEMENT STUDIO) but there is an another option which provided in visual studio IDE.

As in this article, I am using Visual Studio 2017 to create a SQL SERVER database project.

Step 1: Open your Visual Studio 2017

Step 2: Select New -> Project -> Choose Sql Server under Installed templates

SQL SERVER Template in Visual Studio 2017

Step 3: Give a Name for your database and choose the file location where to save and finally click OK.

Step 4: Now, Our database project created successfully.

Created a Sql Server Database using Visual Studio IDE

Step 5: Its time to create a new table, Kindly follow the same steps

Create a new table

Step 6: Click on Table and it opens a window, Give a name for your table, It opens the SQL Editor window,

SQL Editor for creating a new table 

Note: Either use designer or T-SQL to write queries and the changes updates simultaneously. Once your changes/inputs done just save it.

Hoping this article helps you. Thanks

Happy Coding :)