Open DBDiff was developed to be an open source database schema comparison tool for SQL Server 2005 / 2008. It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.

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

What's New in This Release: [ read full changelog ]

· Improve the GUI. Thanks to the ScintillaNET and Ascend Teams!!!!
· Much better performance for big databases.
· Add support for Table Types for SQL Server 2008
· Fix some bugs with FILESTREAM