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, script folders, and native backups. You can quickly compare your SQL Server databases, analyze differences and perform error-free schema synchronization using generated SQL scripts. The tool integrates with SQL Server Management Studio.

  • Compare live databases, SQL Server native backups or script folders
  • Sync staging or production databases with development databases
  • Generate concise and accurate database deployment T-SQL scripts
  • Restore functions and procedures from SQL Server native 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

Schema 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

Export Comparison Report

Handy Generate Comparison Report wizard allows setting up and generating reports on the comparison results in three file formats:

  • HTML - a Hypertext Markup Language file format is perfect for publishing the report in the web. HTML reports also allow presenting script diffs in a report as:
    • Removed-added lines
    • Crossed out words
  • Excel - one of the most popular spreadsheet file formats
  • XML - an extensible markup language file format used to share the data on the World Wide Web

Supported Data

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

  • SQL Server database schemas
  • SQL Azure Cloud objects
  • Script folders
  • Database Snapshots
  • Custom mapped tables
  • SQL Server installed on Linux
  • SQL Server native backups

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
  • Symmetric Key
  • Full Text Catalog
  • Full Text Stoplist
  • Function
  • Message Type
  • Partition Function
  • Partition Scheme
  • Procedure
  • Queue
  • Sequence
  • Role
  • Route
  • Rule
  • Schema

...and much more!

Scripts folder and version control integration

  • Compare objects in scripts folders committed to the source control system
  • Support for Team Foundation Server (TFS), Subversion (SVN), Git and Github version control systems
  • Compare objects in different revisions, including the head revision
  • Create schema snapshots for audit and roll-back purposes

Synchronization features

The synchronization functionality of Schema Compare provides the following options and abilities:

  • Generate deployment scripts for review or synchronization purposes
  • 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

Non-Schema Object Comparison

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

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

Routine Task Automation

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

  • Save comparison project settings for future use
  • Utilize the tool's internal script generation feature to get a PowerShell automation script
  • Use the script in a .bat file and schedule its execution via the Windows Scheduler, automating the schema synchronization process

SSMS Integration

Schema Compare can be easily integrated with SQL Server Management Studio to be used internally from this IDE for schema comparison and synchronization purposes.

Schema Compare
is a part of Compare Bundle

Find out more

Leading companies choose dbForge Schema Compare

Hewlett packard enterprise
Alcoa
Harris
Kroger
Wells fargo

What people say about Schema Compare

Your testimonials
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.
SUNIL
Really awesome product - got company to purchase a licence :) Keep up the great work!
Mike Bowering
Kcom

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 SQL Tools 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

Takes part in DevOps Automation

Use Schema Compare along with dbForge DevOps Automation for SQL Server to extend the DevOps approach to SQL Server databases. The solution makes it easy to integrate SQL Server database into the DevOps process without compromising quality, performance, or reliability.

Explore
dbForge DevOps Automation for SQL Server

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.