Data Compare - Overview

Select Databases

SQL Studio Data Compare offers powerful interface to select remote or local databases for comparison. Ability to compare all tables or user defined selection. Streamline routine jobs by storing compare session for command line integrations and full automation of such tasks.

Compare Data

Fast comparison engine allows rapid compare on complex databases even on remote servers with detailed report of differences found.

Merge Data

Data Compare gives users the flexibility to merge data in both directions, complete database, few tables or table by table. But this is not all - our integrated table compare tool allows each table to be further compared row by row with ability to ignore columns, merge selected rows or even cell by cell. The flexible and user-configurable comparison engine can ignore columns and even track foreign keys relations. Internal data viewer allows easy access to BINARY and NTEXT data and with integration of external diff tools provides more ways for data manipulation!

Synchronize Data

To allow even more flexibility users can alter the final script that is automatically generated based on user merge actions. Save the final script or execute it right away.

Select Tables

SQL Studio Data Compare offers powerful interface to select remote or local databases for compaction of all or custom selected table sets. With ability to store multiple session streamlines the routine compare jobs just to few clicks!

Compare Table Data with Color Coding

Color coding helps visualizing the differences in the data and provides a quick and convenient way to see the comparison results at a glance. In addition, the status icons for each row add a powerful visual indication for each row when working with Data Compare.

Merge Table by Rows & Cells

Merge data in tables row by row with ability to ignore columns, merge selected rows or even cell by cell. The flexible and user-configurable comparison engine can ignore columns and even track foreign keys relations. Internal data viewer allows easy access to BINARY and NTEXT data and with integration of external diff tools provides more ways for data manipulation!

Synchronize Table Data

SQL Studio Data Compare auto generates the merge scripts for both tables separately. The user is allowed to review and alter the scripts if needed, and then copy to clipboard, save or execute each script directly from the tool!