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

Data Compare - Release Info

  • Data Compare version 2.5.704.3550 (4/3/2007)
    • Updated handling of column name case sensitivity

  • Data Compare version 2.5.612.27389 (12/27/2006)
    • Added options for selecting collation during compare
    • Removed excluded columns from script generation
    • Fixed script generation on cancel
    • Disabled Open project when all projects are deleted
    • Fixed encoding issue in script viewer for Unicode characters
    • Fixed project saving when special characters are used

  • Data Compare version 2.5.612.2922 (12/2/2006)
    • Fixed issue when performing summary compare of tables and a column filter with more than one column is defined
    • Fixed issue when deleting duplicate servers in the list of servers
    • Fixed issue when performing compare of tables and the ordinal positions of the columns in the two tables are different
    • Fixed issue when performing summary compare of tables in which the ordinal positions of the columns in the tables are different

  • Data Compare version 2.5.611.29746 (11/29/2006)
    • Target database backup option before executing scripts
    • Row filtering using a custom WHERE clause
    • Command line utility function for comparing database projects
    • Command line utility database compare reports
    • Custom templates for command line utility reports
    • Date format option for output scripts
    • Capability for generating INSERT only statements in output scripts (database dumping)
    • Context menu on tabs upon right click
    • Option to choose between using information schema views or system tables for SQL Server meta data retrieval
    • Auto complete for Server/Database/Table Combo boxes when creating/editing a session
    • Command line utility options to specify linked servers
    • Fixed issue with occasional adding server twice to the list of servers
    • Fixed issue preventing compare of a table that has first column with data type "uniqueidentifier"
    • Fixed issue preventing compare of two tables that have columns with data type "sqlvariant"
    • Fixed issue with checking number of rows
    • Fixed named instances server listing issues

  • Data Compare version 2.3.609.7937 (9/7/2006)
    • Ability to sync only differences
    • Added capability to enter NULL values in cell edit mode via Ctrl+0
    • New option to refresh on the Database compare screen
    • Fixed scripting for NULL values in bit fields

  • Data Compare version 2.1.608.25943 (8/25/2006)
    • Command line interface
    • Multiple server locations
    • Define custom primary keys
    • New comparison wizard and project definitions
    • Improved speed and performance
    • Improved user interface

  • Data Compare version 1.11.604.14448 (4/14/2006)
    • Compare all tables in two databases, or a selection of tables
    • Save compare sessions
    • Color coding for differences
    • Filter the data to show only differences
    • Support for remote servers
    • Powerful synchronization options for all rows, selected rows, selected columns
    • Flexible options for comparing BINARY and NTEXT data using third-party diff tools
    • Filters by rows and columns
    • Data search by keywords
    • Support for Microsoft SQL Server 2005
    • Advanced recognition of SQL Servers on the network
    • In place cell editing
    • Comparison for XML fields in SQL Server 2005