Скачать или смотреть Compare And Update SQL Server Database Project With Visual Studio

Problem
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 script we had 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.

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

We can create a new database project and compare from 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).

Links
Microsoft SQL Server: https://www.microsoft.com/en-us/sql-s...
VisualStudio: https://visualstudio.microsoft.com/

Follow me
Twitter:   / habibdeveloper  
Github: https://github.com/habib-developer
LinkedIn:   / habibdeveloper  
StackOverflow: https://stackoverflow.com/users/55592...
C# Corner: https://www.c-sharpcorner.com/members...