Data Compare Info

Overview
Screenshots
Technical Details
Tutorial
Data Compare FAQ
Release Info
Coming Soon
Data Compare Data sheet (PDF)
Case Studies and Examples (PDF)
Competitive Feature Chart (PDF)
How to Compare Data in Tables
How to Compare Data in Databases

Free offer for Microsoft MVPs

Data Compare

Apr 03, 2007
Build 2.5
Try | Buy | Update

VeriTest Tested

SQL Studio Data Compare passed the Microsoft Platform Test for ISV Solutions for the following components:
- Windows Client (Windows XP)
- SQL Server (on SQL Server 2005)

Testing was conducted independently by VeriTest, a testing service of Lionbridge Technologies.

SQL Server 2005 Front Runner


Shareup Networks


Free Trial Soft - Five Stars


Free Trial Soft - Editor's Choice


SQL Studio Data Compare

Data Compare - Overview

Overview - Database Compare

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.


Overview - Table Compare

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!