dbForge Data Compare for SQL Server Features

What SQL Server versions are supported?

• SQL Server 2012, 2008, 2005, 2000 databases
• SQL Server Express 2012, 2008 and 2005 databases
• SQL Azure databases

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

View the list of features regarding editions at the Editions page.