KS DB Merge Tools
 
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
and MariaDB
for SQLite
 

Compare and synchronize SQL Server DB schema and data


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

  • Compare schema and data
  • Quick filters to show all/new/changed/new+changed
  • Merge changes in both directions
  • Free version with basic features, available for commercial use
  • Pro version with whole set of features at a reasonable price
  • Free Pro
    Supported SQL Server versions: 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 and SQL Azure
    Compare schema & programming objects: Tables (columns, primary key, default constraints) diff only
    Views
    Stored procedures
    Functions
    Schemas merge new only
    Tables (columns, primary key, default constraints) merge new only
    Table constraints (default, check, unique)
    Table indexes
    Table change tracking merge new only
    Triggers
    Foreign keys
    Stored procedures
    Functions
    User-defined data types
    User-defined table types
    Sequences merge new only
    Compare data: Per table with limitations Per table
    Per view
    Batch data diff across multiple tables/views
    Any table/view vs any other table/view merge only if target updateable
    Any custom query result diff only
    Search across object definitions: Basic Advanced
    Other Pro features: N/A Export to Excel requires MS Excel
    Application customization
    Scripting support for data merge
    Misc. other enhancements: diff totals, scrollbars colored with changes summary, navigation thru changes, etc.
    Price: Free, download Personal license: USD $75, buy now
    For companies and organizations: from USD $40 per user, buy now
    Fully functional two weeks trial available, download