Compare and Sync SQL Server Schema and Data

MssqlMerge is an easy to use diff & merge tool for Microsoft SQL Server databases:

Compare both schema and data
Quick filters to show all/new/changed
Merge changes in both directions
Lightweight GUI for Windows, command line for Windows and Linux
Free version with basic features, available for commercial use. No credit card, no signup, no ads, no hidden telemetry.
Standard version with whole set of features at a reasonable price. Free 14 days trial available.
Supported SQL Server versions: 2008 .. 2022 and SQL Azure

Screenshots and Use Cases

Scroll the gallery and click on the image title to open the use case with detailed steps. Use the toggle to switch application modes, if applicable.

MssqlMerge - Schema changes summary (thumbnail)

MssqlMerge - Data changes summary (thumbnail)

MssqlMerge - Compare and synchronize data (thumbnail)

MssqlMerge - Compare ad-hoc query result (thumbnail)

MssqlMerge - Compare and synchronize table definition (thumbnail)

MssqlMerge - Automation and Scripting (thumbnail)

MssqlMerge - Compare non-table schema objects (thumbnail)

MssqlMerge - Compare object definition (thumbnail)

Schema changes summary

Data changes summary

MssqlMerge - Compare and synchronize data

MssqlMerge Free - Compare and synchronize data

Compare table data

Compare ad hoc query result

MssqlMerge - Compare and synchronize table definition

MssqlMerge Free - Compare and synchronize table definition

Compare table schema

Automation

MssqlMerge - Compare non-table schema objects

MssqlMerge Free - Compare non-table schema objects

Compare list of objects

Compare object definition

Free vs Standard

	Free	Standard
Price (USD, excluding VAT):	$0	Single-user personal license:	$95 BUY NOW
		Multi-user license for companies and organizations:	$120 ~ $75 per user, volume discounts: 5 users: $450 ($90 per user) 10 users: $850 ($85 per user) 20 users: $1500 ($75 per user) BUY NOW
		Payments are handled externally by PayPro Global (Toronto, Canada), transactions are encrypted and secure This is a perpetual license including a one-year of free upgrades More about purchasing, license types and discounts
Compare schema and programming objects:	Tables (columns and constraints) ^{merge new only} Views (definition) Stored procedures Functions Schemas ^{merge new only}	Tables (columns, constraints, indexes, triggers and change tracking) Views (definition, indexes and triggers) Stored procedures Functions User-defined data types ^{merge new only} User-defined table types ^{merge new only} Sequences ^{merge new only} Schemas ^{merge new only} XML schema collections ^{merge new only} DDL triggers Other objects can be compared by querying system metadata
Compare data:	Per table ^{with limitations}	Per table Per view Any table/view vs any other table/view ^{merge only if target updateable} Any custom query result ^{diff only} Batch data diff across multiple tables, views, custom mappings and custom queries Data slices (customized subset of Batch data diff)
Other Standard features:	N/A	Diff profiles Id-Remap Merge Export to Xlsx and Json Application customization Misc. other enhancements: scrollbars colored with changes summary, navigation thru changes, advanced search, etc. More about Standard features
Command line:	For Linux ^{with limitations}	For Linux For Windows Script Editor GUI

Free	Standard
Price (USD, excluding VAT):
$0	Single-user personal license: $95 BUY NOW Multi-user license for companies and organizations: $120 ~ $75 per user BUY NOW More about purchasing and license types
Compare schema and programming objects:
Tables (columns and constraints) ^{merge new only} Views (definition) Stored procedures Functions Schemas ^{merge new only}	Tables (columns, constraints, indexes, triggers and change tracking) Views (definition, indexes and triggers) Stored procedures Functions User-defined data types ^{merge new only} User-defined table types ^{merge new only} Sequences ^{merge new only} Schemas ^{merge new only} XML schema collections ^{merge new only} DDL triggers Other objects can be compared by querying system metadata
Compare data:
Per table ^{with limitations}	Per table Per view Any table/view vs any other table/view ^{merge only if target updateable} Any custom query result ^{diff only} Batch data diff across multiple tables, views, custom mappings and custom queries Data slices (customized subset of Batch data diff)
Other Standard features:
N/A	Diff profiles Id-Remap Merge Export to Xlsx and Json Application customization Misc. other enhancements: scrollbars colored with changes summary, navigation thru changes, advanced search, etc. More about Standard features
Command line:
For Linux ^{with limitations}	For Linux For Windows Script Editor GUI

If you have any questions, please contact us.