Compare and Sync
SQL Server Schemas

Schema Comparison Result Analysis

• Filter, group, and sort objects in results
• View DDL differences for each object pair with word wrap, view white spaces, show line numbers, view hex, show columns and constraints alphabetically, format database object script options
• View the text comparer in the detached window on a different screen
• Select an individual object, a group of objects, or all objects for synchronization
• Change the type of an operation to None or Drop
• Preview the schema update deployment 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 Sources

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

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

Supported Schema Objects

Wth Schema Compare, you can apply the Object Filter feature and compare the following schema objects:

Scripts folder and version control integration

• Compare objects in script folders committed to the source control system
• Support for Team Foundation Server (TFVS), Subversion (SVN), Git, Github, and Azure DevOps 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 sync issues ensures error-free script deployment
• Warnings on controversial points prior to deployment

Non-Schema Object Comparison

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

• 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 the code of stored routines
• Ignore differences in identifier, keyword case, and reduction
• 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 and task automation
• Use the tool's internal script generation feature to get a PowerShell script
• Use the script in a .bat file and schedule its execution via the Windows Scheduler, automating schema synchronization
• Set up Continuous Integration (CI) and Continuous Delivery (CD) with dbForge DevOps Automation for SQL Server

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.

• Set a database as source or target
• Set a scripts folder as source or target
• Set a source control version as source or target