Database Project in Visual Studio
While developing any application we face problem in maintaining database changes. Problem occurs when we want to update existing database or add something new to it or maintaining version control to the changes. Database comes in handy this place, we can use database projects to create new databases, new data-tier applications (DACs), and to update existing databases and data-tier applications. We can help our development team to manage changes to databases and database servers by creating a database project and putting it under version control. Steps to Create Database project Step 1: Open visual studio (I’m using VS 2015) and create a new project. Step 2: Go to "File" -> "New" -> "Project". Step 3: Select "SQL Server" in the installed templates. Step 4: Select "SQL Server Database Project". Step 5: Enter the Name, choose the location and click "OK" In the solution explorer right