Compare and Sync
SQL Server Schemas

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:

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.