Contents
Introduction
Welcome to SQL Server Comparison Tool
With SQL Server Comparison Tool, you can take full control of your databases. You can
- Analyze and compare structure of Tables, Procedures, Functions, Views, Triggers and Relationships in any of your SQL Server databases
- Compare data stored in tables
- Generate detailed reports displaying results of comparisons or analysis
- Export data differences reports to HTML file or Excel (CSV) file (even if the computer performing analysis doesn't have Excel installed)
- Filter objects by their ownerships
- New! Perform bulk comparisons and selective comparison
- New! Ignore selected columns during comparisons
- New! Fine tune data comparisons by specifying comparison method (record-by-record or primary key/index comparison)
- New! Save ("record") comparison sessions so that they can be re-played later without need of re-entering the parameters
- New! Automate comparisons by using command line parameter
- New! Compare selected parts of object (table, procedure, etc) definitions
Analysis and comparisons can be performed even on databases belonging to different servers.
SQL Server Comparison Tool is an ideal tool for Database Administrators and Developers.
Please note that SQL Server Comparison Tool is very safe, "read-only" program. Using it will never affect any data stored in your databases. SCT is a tool designed to perform analysis and comparisons; it is not designed to change any structure or data.