SQL Data Compare

Automate data migrations, analyse corrupted data, restore row-level data from backups, compile audit trails of missing or changed data and SQL scripts under source control.

SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents. You can work with live databases, backups or SQL scripts in source control. With the command line interface you can automate tasks and schedule comparisons to easily create an audit trail. Damaged or missing data can be restored to a single row, without the need for a full database recovery.

It is available in the following editions:

• SQL Data Compare Standard Edition: Compare and synchronise SQL database contents.
  
• SQL Data Compare Professional Edition: Create an audit trail by comparing backups, backup target database before changes are migrated and command line automation for continuous integration.

Key Features:

Standard Edition:

• Save time comparing and synchronising data
  
• Copy lookup data from development databases to staging or production
  
• Generate T-SQL scripts to update one database with the contents of another
  
• Keep an accurate history of all previous database records
  
• Compare and synchronise data from within SQL Server Management Studio
  
• Deploy to SQL Server, SQL Azure and SQL Server on Amazon RDS

Professional Edition:

• All Standard edition features
• Quickly fix problems by restoring damaged or missing data to a single row
  
• Deploy databases from source control
  
• Compare and synchronise from backup files
  
• Automate comparison and synchronisation tasks with DLM Automation
  
• Run SQL Data Compare Pro on your build server for continuous integration, with DLM Automation

SQL Data Compare - Features

The SQL Server tools consist of products for DBAs and developers to compare and synchronize databases structures, database contents and SQL Servers.

SQL Data Compare is used for comparing and synchronizing the contents of two databases. Use it to save time and work synchronizing two databases when the data between them has got out of synch, or as a tool for QA, documentation and verification.

Use SQL Data Compare when:

• Data between two databases is out of sync. Use SQL Data Compare to identify the differences and run the script generated to make your databases the same
• Replication has failed and user need to know why. Use SQL Data Compare to identify differences and synchronize data
• Moving data between two databases. SQL Data Compare identifies the differences and allows user to choose the direction to move data.

New features in version 5.1:

• Bug fixes
• Updated help file
• Complete redesign of the graphical user interface and engine
• Improved side-by-side comparison of column values
• Added new interactive help information
• Added support for:
  • Project management, including the ability to specify options for each project
  • Creating custom comparison keys
  • Mapping owners (or schemas), objects and columns
  • Filtering rows using WHERE clauses
  • Forcing binary collation on strings
  • Using checksum comparisons on large volumes of data that change infrequently
• Improved SQL Server Instance detection.

New features in version 4.1 include:

SQL Server 2005 support

• String into XML data fields conversion
• String into CLR data type conversion
• XML type supported with DTD support for translation
• CLR data type transport as text or binary
• varchar(max), varbinary(max) and nvarchar(max) all supported
• XML Indexes fully supported
• CLR Triggers fully supported
• DDL triggers supported
• Quicker SQL scripts for large objects
• Improved collation support for foreign languages
• Interface now localized for German and Japanese in addition to English

Features include:

• Simple to use, and hides complexity from the user. Once the comparison has been completed, a script is automatically generated
• SQL Data Compare integrates with SQL Query Analyzer
• Choose data to synchronize on a row-by-row bases.

SQL Data Compare - System Requirements

• Windows NT, Windows 2000, Windows 98, Windows ME, Windows XP or Windows 2003 Server
• SQL Server client-side tools (SQL Compare)
• Microsoft .NET Framework 1.0.3705+
• MDAC 2.6+
• 128 MB RAM, 10 MB hard disk space
• Runs on a user's PC (can also run on a server)
• Visual Studio .NET, or similar programming environment that uses the .NET Framework (SQL Toolkit only)