Quickly Compare Databases with Robust Comparison Engine
Compare extensive schemas and data between two databases fast while tightly controlling resource utilization with the comparison engine. The comparison engine is robust, highly efficient, easily configurable, and scalable. Synchronize without any technical limitations in the size of the databases.

View Comparison Results
Display a side-by-side, summary of the color-coded results of the comparison to pinpoint at-a-glance similarities and differences between two database objects. The summary includes objects in the source but not in the target and vice versa, identical objects, and the counts of the selected objects. Filter the comparison results based on the object type (such as tables and views) and the status (such as identical and different) of the compared objects.

Filter by Objects
Apply comparison filters to any object including tables, stored procedures, views, user-defined functions, extensible markup language (XML) schema collections, and common language runtime (CLR) assemblies to efficiently manage objects. Specify the name of object types to include or exclude them.

Rerun Comparison with Single Click
Maintain a history of comparison sessions consisting of persisted environments with all of the data related to a comparison operation. This data includes databases and credentials, comparison options, scripting options, execution options, included and excluded object types, and included and excluded individual objects. Repeat a comparison with a single click with these sessions. Control how to sort sessions and the maximum number of persisted sessions with application options.

Take Schema Snapshots
Save snapshots of schemas to maintain an audit trail of schema changes. Compare snapshots and compare snapshots to live databases. Maintain a history and audit trail of schema changes. Reverse schema changes efficiently and safely. Compare schemas with their snapshots, taken immediately before implementing changes. Generate SQL script for reversing schema changes.

Create Project Workspaces
Create and store different workspaces that contain snapshots and comparison sessions for different sets of instances and databases. Easily navigate back to these workspace snapshots to jump straight into a comparison operation.

Save Comparison Sessions
Save all of the settings and configuration options related to a comparison operation (such as databases, credentials, options, mapping rules, scripting options) to re-run of comparison operations with a single mouse click.

Customize Comparison Sessions
Comparing database objects is not straightforward. For example, two tables may be equal when ignoring column collation, but not equal when considering collation. Also, two stored procedures may be equal when ignoring character case, but not equal when considering character case. Further, two indexes may be equal when ignoring the fill factor, but not equal when considering the fill factor. Completely control the comparison engine with more than one hundred exposed comparison options.

Customize Mapping Rules
Customize the way objects of databases are paired together with mapping rules. For example, map renamed objects. Use mapping rules to customize the pairing of schemas, object names, and data types. Determine how schemas map with schema mapping rules. Determine how object names map with name mapping rules. Determine how data types map with data mapping rules.

Create Custom Comparison Keys
Compare tables and views of databases when they are non-compare because of an absent primary key and absent unique indexes. After analyzing the schemas, define a unique key for the comparison. The key consists of any combination of the columns of the table. The rows of the table are paired based on the selected key.