What can be compared and synchronized?

  • Tables
  • Views
  • Database backups
  • Custom queries
  • Scripts folder
Objects to Be Compared

Scripts Folder

Data Compare for SQL Server compares not only database backups, tables, views but also static data from local scripts folder against a database of a source control project.

Scripts Folder

Data comparison setup

  • Include tables or views into comparison by mask or individually
  • Exclude objects from comparison by mask or individually
  • Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables)
  • Float types rounding option
  • Ignore Case and Ignore Trailing Spaces options for string comparison
  • LOB comparison options
  • WHERE filter for limiting data that needs to be compared (e.g. in extra large tables)
Data Comparison Setup

How can I compare data in two databases with different structures?

  • User mapping feature allows comparing tables with different names and column set
  • Map one table in source with two or more tables in target (useful when table was split)
  • Custom Query feature allows comparing a table with a query result
Column Mapping

How can I analyze comparison results?

  • Filter and sort objects in results
  • View data differences for each pair of objects
  • Quickly navigate through data differences
  • Perform full-text search in data
  • View number of changes per column
  • Hide unmodified columns to simplify analysis
  • Select arbitrary columns for display
Analyzing Comparison Results

How can I export data comparison results?

  • Generate data comparison report in Excel and HTML formats
  • Include actual data into report
  • Report on selected objects only
Exporting Comparison Results

Synchronization features

  • Create accurate synchronization scripts
  • Migrate individual records, groups of records, or all data differences
  • Toggle synchronization direction to apply data changes to both databases
  • Rollback changes on error
  • Synchronize LOBs via files
  • Warnings on possible problems prior to synchronization
Data Synchronization

How can I automate my routine tasks?

  • Save comparison project settings for future use
  • Use command line interface for automatic routine synchronizations
Command Line Use