issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

What can be compared and synchronized?

  • Tables
  • Views
  • Database backups
  • Custom queries
  • Scripts folder

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.

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