dbForge Data Compare for SQL Server Features

This page provides a comprehensive listing of features available in dbForge Data Compare for SQL Server. For a list of new features, see What's New in 4.1.

What can be compared and synchronized?

  • Tables
  • Views
  • Database backups
  • Custom queries

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)

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

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

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

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

How can I automate my routine tasks?

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