Comparing Groups of Scripts

SQL Admin Tools Quick Compare can compare an entire database, groups of scripts or individual scripts.  To compare a type of script, such as Views, or Stored Procedures, expand the required database and select the script group.

In the example below the Procedures (Stored Procedures) group has been selected from the Metrics database on the red (left) server, and is to be compared to the Metrics_Dev database on the green (right) server.

Compare SQL Server Stored Procedures

Selecting the compare button automatically compares just the Procedures between these two databases, with the results shown to the far right under the scales icon.

Comparison of SQL Server Scripts

Microsoft SQL Server compare databases

Get SQL Quick Compare Free

Microsoft SQL Server compare databases