Comparing Individual Scripts

SQL Admin Tools Quick Compare can compare an entire database, groups of scripts or individual scripts.  To compare a specific script expand the required database and script group then select the script to be compared.

SQL Script Diff

The results will be shown in the far right panel under the scales.  If the script only exists in the red database the name will appear in the results panel with a red background highlighting.  If the script only exists in the green database the name will appear in the results panel with a green background highlighting.  If the script exists in both databases but doesn't exactly match it will appear in the results panel with a yellow highlighting.  If the script exists in both databases and the script in both databases match it will not be included in the results panel.

In the example below the view Data_Sizes appears in both databases but has differences between the two databases

Compared SQL Server Script

Microsoft SQL Server compare databases

Get SQL Quick Compare Free

Microsoft SQL Server compare databases