• Buy Now
  • Download
sql server comparison tool
  • Home
  • Pricing
  • Screens
  • Contact
SQL Server Comparison Tool User Guide
Overview
Getting Started
Adding server to SCT
Removing server from SCT
Keyboard Shortcuts
Toolbar
Getting database information
Structure Comparisons
Comparing selected objects
Comparing all objects
Bulk comparisons
Selective comparisons
Data Comparisons
Comparing data in two tables
Data comparison options
Comparing data in two tables
Exporting data from table to HTML file
Exporting data from table to Excel file
Automating Comparisons
Saving Comparisons
Command Line Parameter
Ordering & License
License agreement
System requirements
Technical Support
Contacts & Credits
< Previous page Next page >

Bulk comparisons

 
You can compare all objects of given type at once, in one comparison process. To do so please select menu item Structure Comparisons -> Bulk Comparisons, then appropriate sub-menu - Simple or Details, and the type of objects to be compared.
 
Simple comparisons display only statistics in final report - the list of objects that differ.
Detailed comparisons display statistics and the list of differences for each object that differs across compared databases.
 
 

Examples:

 
Structure Comparisons | Bulk Comparisons | Simple | Compare All Tables
 
- the structures of all tables in both databases will be compared and the list of different tables will be displayed in final report.
 
 
Structure Comparisons | Bulk Comparisons | Details | Compare All Procedures
 
- all stored procedures in both databases will be compared and the list of different procedures, along with the list of differences inside each of procedures, will be displayed in final report.