About dbForge Schema Compare for SQL Server

Compare and synchronize structures of Microsoft SQL Server databases.

dbForge Schema Compare for SQL Server lets you quickly and safely perform schema comparison and synchronization along with easy analysis of database structure differences. dbForge Schema Compare for SQL Server is specially designed to help you quickly analyze database structure differences at a glance and propagate the changes to a required SQL Server escaping tedious manual work.

dbForge Schema Compare for SQL Server Features

Standard Edition Features

  • Comparison of all SQL Server database objects
  • Comparison and synchronization of database properties
  • Creation and comparison of schema snapshots
  • Rich options to customize schema comparison and synchronization
  • Generating comparison and synchronization reports
  • Execution of extra large scripts

Professional Edition Features - everything in the Standard Edition plus:

  • Comparison of native SQL Server backups
  • Support of version control system to track database changes
  • Command line interface

SQL Server Connectivity

  • Comparison and synchronization of databases on different SQL servers
  • Connection Manager for a full control of database connections

Database Structure Comparison

  • Accurate comparison with Schema Comparison wizard
  • Comparison of all major SQL Server database objects
  • Options for tables and script-based objects comparison
  • Object filter to compare only required object types
  • Custom schema mapping (one-to-many)

Analyzing Structure Differences and Synchronization

  • Automatic grouping of objects by type
  • Convenient filtering and sorting of comparison results
  • Objects exclusion from synchronization
  • Save and load comparison settings
  • Detailed synchronization script plan
  • View the synchronization script for any separate schema object
  • Ability to backup Target database before synchronization
  • Automatically compiled list of objects to add to synchronization based on object dependencies
  • Options to customize the synchronization script output
  • Warnings on possible data losses or errors during synchronization
  • Asynchronous structure synchronization

SQL Execution and Data Management

  • Execution of SQL scripts and queries
  • Data editor with in-place filtering, grouping, and sorting options
  • Paginal data access for large result sets
  • Graphical card view for data editor
  • Large objects (LOB) editor
  • Text search in data editor
  • Data printing
  • Ability to postpone sending of data updates to the server (Cached updates mode)

Clear User Interface

  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Tabbed groups for documents
  • Toolbars customization