A GPL2 database comparison tool for Microsoft SQL Server 2005+ that reports schema differences and creates a synchronization script.

Don't miss a year's worth of updates ready for testing: Open DBDiff 0.9

Build status

Open DBDiff can synchronize
  • Tables (including Table Options like vardecimal, text in row, etc.)
  • Columns (including Computed Columns, XML options, Identities, etc.)
  • Constraints
  • Indexes (and XML Indexes)
  • XML Schemas
  • Table Types
  • User Data Types (UDT)
  • CLR Objects (Assemblies, CLR-UDT, CLR-Store Procedure, CLR-Triggers)
  • Triggers (including DDL Triggers)
  • Synonyms
  • Schemas
  • File groups
  • Views
  • Functions
  • Store Procedures
  • Partition Functions/Schemes
  • Users
  • Roles

I didn't find any tool like this 100% open source for SQL Server. It does not depend on any privative tool or component. I do its work without resorting to SMO.
We tested this tool with more than 100 distinct testing use cases.


Last edited Apr 12 at 1:11 AM by jspraul, version 12