SQL Compare includes a free add-in for SQL Server Management Studio that lets you compare and deploy databases (including versions from source control) from Management Studio.
The add-in is bundled with the SQL Compare installer, which you can download here. When you run the installer, make sure the SSMS Integration Pack check box is selected:
To compare two databases from Management Studio:
The Schema and Data Compare tab is displayed, with the database you selected set as the source in the leftmost pane:
To switch the source and target and databases, click .
For more information on selecting databases to compare in SQL Compare, see: Setting data sources.
The SQL Server Management Studio add-in enables you to compare and deploy versions of a database linked to SQL Source Control 1.1 or later.
To set a version from source control as a data source:
The Schema and Data Compare tab is displayed, with the database you selected set as the source in the leftmost pane: