Compare And Update SQL Server Database Project With Visual Studio

Introduction

When we are working on any project, a database plays an important role, and after some time when the number of tables, views, and store procedures increases, it becomes too difficult to manage the database changes. It's very difficult to update production database projects.

And even after that when we manage the database, then we still need to compare which scripts we have worked on and which are remaining on any particular database. There are many good tools available in the market for comparing databases but most of them are paid.

So, in this article, we’re going to learn about how we can manage our database scripts using Visual Studio’s SQL Server Database Project.

We can create a new database project and compare it with an existing database, a .sql script file, or a Data-tier application (.dacpac). We can then invoke the same visual designer tools (Transact-SQL Editor, Table Designer) available for connected database development to make changes to the offline database project, and publish the changes back to the production database. The changes can also be saved as a script to be published later. Using the Project Properties panel, we can change the target platform to different versions of SQL Server (including SQL Azure).

Prerequisite

VS2015 or VS2017 or VS2019 should be installed on your machine.

Getting Started

• Open Visual Studio and create a new project from the Menu, Select File > New > Project.

• Select the SQL Server Database Project from the list.

• Enter the Project name and click on create button.

• After the project is created, we can see the database project in Solution Explorer.