Project DescriptionOpen DBDiff is a open source database schema comparison tool for SQL Server 2005. It reports any differences between two database schemas and provides a synchronized 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, Identitys, etc..)
* Constraints
* Indexes
* Data Types
* Triggers (including DDL Triggers)
* Assemblys
* Synonyms
* XML Schemas
* Schemas
* FileGroups
* Views
* Store Procedures
I didn't found any tool like this 100% open source for SQL Server. It's not depend from any privative tool or componet. Scripting without SMO.
We test this tools with almost 60 distinct testing use case.
We are working know to add SQL Server 2000 and MySQL 5.x in the proyect.
Additional information on starting a new project is available here:
Project Startup Guide.