Compare and Sync SQL Server Schemas

dbForge Schema Compare for SQL Server is a reliable database comparison tool that saves you time and effort when comparing and synchronizing SQL Server databases. This tool allows you to work with live SQL Server databases, snapshots, and backups. You can quickly compare your SQL Server databases, analyze differences and perform error-free schema synchronization using generated SQL scripts.

  • Compare live databases, backups or script folders
  • Sync staging or production databases with development databases
  • Generate database synchronization SQL scripts
  • Restore functions and procedures from backups
  • Automate routine synchronization tasks with command-line interface
  • Deploy to SQL Server, SQL Azure, and SQL Server on Amazon RDS
  • Export schema comparison results to HTML, Excel, and XML

Features

Supported Data

You can use the following objects as Source and Target for schema comparison and synchronization:

  • SQL Server database schemas
  • Snapshots of schemas
  • SQL Server 2005 - 2016 backup files
  • Custom mapped tables
dbForge Schema Compare for SQL Server - Supported Data
dbForge Schema Compare for SQL Server - Supported schema objects

Supported Schema Objects

When you compare SQL databases in Schema Compare, the following schema objects are supported:

  • Application Role
  • Assembly
  • Asymmetric Key
  • Broker Priority
  • Certificate
  • Contract
  • DDL Trigger
  • Default
  • Event Notification
  • External Data Source
  • Full Text Catalog
  • Full Text Stoplist
  • Function
  • Message Type
  • Partition Function
  • Partition Scheme
  • Procedure
  • Queue
  • Remote Service Binding
  • Role
  • Route
  • Rule
  • Schema
  • Search Property List
  • Security Policies
  • Sequence
  • Service
  • Symmetric Key
  • Synonym
  • Table
  • User
  • User Defined Type
  • View
  • XML Schema Collection

Schema snapshots and version control integration

  • Create schema snapshots for audit and roll-back purposes
  • Automatically commit snapshots to a version control system
  • Compare previous versions of a schema with the current one (integration with Team Foundation Server and Subversion supported)
dbForge Schema Compare for SQL Server - Version control integration

Comparison Result Analysis

  • Filter, group, and sort objects in results
  • View DDL differences for each object pair
  • Preview the schema update script for each object
  • Generate a schema comparison report in Excel and HTML formats
dbForge Schema Compare for SQL Server - Comparison Result Analysis

Synchronization features

Schema Compare can act as a powerful SQL server synchronization tool. The synchronization functionality of Schema Compare provides the following options and abilities:

  • Create accurate synchronization scripts
  • Migrate any schema differences (individual, selected, or all)
  • Dependency check to script objects in the correct order for updates
  • Automatic resolution of synchronization issues
  • Warnings on controversial points prior to synchronization
dbForge Schema Compare for SQL Server - Synchronization features

Non-Schema Object Synchronization

In addition to database schema synchronization, you can synchronize the following types of objects using Schema Compare:

  • Database properties
  • Extended object properties
  • Per-object security permissions
dbForge Schema Compare for SQL Server - Non-schema object synchronization

T-SQL Code Comparison

dbForge Schema Compare for SQL Server allows you to efficiently compare T-SQL code with the following options:

  • Ignore white spaces and comments in code
  • Ignore differences in identifier and keyword case
  • Decrypt and compare encrypted objects
dbForge Schema Compare for SQL Server - T-SQL code comparison

Script Generation

dbForge Schema Compare allows you to generate scripts to compare SQL Server schemas. The following options are available in Schema Compare script generation:

  • Schema Export (Generate Script Wizard)
  • Schema-only backups in addition to full backups
  • Large database support
  • Generate Script projects to save settings for future use
  • Zip compression for export files
  • Command line support for scheduling schema export tasks
  • Error and status logging
dbForge Schema Compare for SQL Server - Script generation

Routine Task Automation

Completing routine tasks becomes easier and more convenient with Schema Compare's automation capabilities:

  • Save comparison project settings for future use
  • Use the command line interface for automatic routine synchronizations
dbForge Schema Compare for SQL Server - Routine task automation

SSMS Integration

Schema Compare can be easily integrated with SSMS to be used internally from this IDE for schema comparison and synchronization purposes

dbForge Schema Compare for SQL Server - SSMS Integration

Schema Compare is part of Compare Bundle

I feel I made a very good decision in buying different products from Devart. Products like Schema Compare for SQL Server, SQL Complete and Code Compare are excellent products.

Get Started with dbForge Schema Compare at no cost

Download a FREE 30-day trial and start saving time spent on your database deployments today.

Download for free

Buy multi-user licenses with substantial discount

If you have any questions about the tool and its purchase options, feel free to contact our sales team.

Purchase now

Try Developer Bundle with Schema Compare included

Sync schemas, deploy from version control, write SQL, and more with our mega pack of SQL Server tools.

Find out more
I feel I made a very good decision in buying different products from Devart. Products like Schema Compare for SQL Server, SQL Complete and Code Compare are excellent products.
user feedback
Sunil