In this lesson, Kendra shows how you can use SQL Compare with SQL Change Automation projects in Visual Studio to compare database state at different points in your project.

In this video:

00:16 – How the SQL Compare is used by SQL Change Automation under the hood
1:03 – Demo begins with a view of the Northwind SQL Change Automation Project in Visual Studio
1:50 – Demo of setting up the source and target in SQL Compare, with discussion of how this comparison uses programmable objects and the offline schema model
4:23 – View of the results of the comparison
5:06 – Demo of creating and checking out a branch in Git via Visual Studio
6:37 – Demo of refreshing SQL Compare after the branch switch in Visual Studio, and how and why the results change
7:53 – Demo of switching back to the master branch and a few of how this once again changes the comparison being performed (in a good way)