About dbForge Data Compare for SQL Server

Compare and synchronize Microsoft SQL Server databases.

dbForge Data Compare for SQL Server is a fast, easy-to-use tool for accurate comparing and synchronizing data of Microsoft SQL Server databases. It provides extended custom mapping opportunities, allows working with SQL scripts and queries and presents a useful toolset for data management.

dbForge Data Compare for SQL Server Features

Custom mapping of tables, columns, and schemas - You can manually map tables, their columns, views, and even the schemas, which can't be mapped automatically. This is helpful when you want to compare the following:

  • Objects with different data structures
  • Columns of the objects with different data structures
  • Identical schemas with different names

Convenient comparison wizard - The comparison wizard helps you quickly select databases, include required objects in comparison, and start the comparison. Also you can set up additional options. Following the wizard pages is convenient and guarantees accurate data comparison.

Full control of data synchronization - Data Compare generates the synchronization script, which you can either execute against the Target database, or save to a file, or open in SQL editor.

Integrated SQL editor - Using SQL editor, you can view, edit, and execute synchronization scripts or create and execute queries. The Data window offers a wide number of options for managing retrieved data. For example, you can use card and grid modes for better view; group, sort, and filter data in the grid; benefit from the cached updates option and more.

dbForge Data Compare for SQL Server Standard Features:

  • Support for SQL Server
  • Comparison of tables and views
  • Rich options to customize data comparison and synchronization
  • Custom mapping of tables, columns, views, and schemas
  • Execution of SQL files and scripts

dbForge Data Compare for SQL Server Professional Features - all Standard features plus:

  • Comparison of native SQL Server backups
  • Generating comparison and synchronization reports
  • Command line interface