Compare Two Databases, Find Differences and Update using Visual Studio

In this post, we are going to start off with an introduction of SQL Server Database Project. Then, we will learn how to connect two databases: source and target, compare and identify differences among the two databases, update or generate script to update the target database.