• 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 Print version Next page >

Comparing data in two tables

 
To compare data stored in two tables:
  • Select appropriate tables in both panels (left panel and right panel)
     
     
  • Click button "Compare data"
     
     
  • Optionally, select appropriate settings in Data Comparison Options window, where you can customize and fine tune the comparison process.
     
  • The comparison of data stored will be performed and the results will be displayed in Report window. You can export the report to HTML file or to Excel (CSV) file.