In this video, I am going to show you how you can track and manage MS SQL Server database schema changes. In a large team, database management and alteration become too complex. By using this database project in Visual Studio, you can track everyone's all change into Git just like your code.
 
This way, the developers can know the history of a single SQL object from GIT. The database project keeps the .sql file for every database project like tables, stored procedures, views, functions, UDT. There is a schema compare option in Visual Studio in which you can compare your changes with the local database and make all updates into the project in a single click. This is a smart way to manage your database changes in large scale projects.
 

Dharmraj Thakur is angular and .net core developer and technical author holding degree of Masters of Computer Application. Professionally he is .Net MVC developer with expertise of Angular & Reactjs, asp.net, asp.net MVC, Design Pattern, SQL, Jquery, Web API, SEO. He like to create automation tools, automated scripts, web scrapping, community contribution.