OpenDBiff Wiki & Documentation Rss Feed

Updated Wiki: Home

Grimpi — Tue, 24 Mar 2009 23:54:53 GMT

Project Description
Open DBDiff is 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

I didn't found 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.

Additional information on starting a new project is available here: Project Startup Guide.

Updated Wiki: Home

Grimpi — Mon, 02 Feb 2009 00:42:28 GMT

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
User Data Types (UDT)
CLR Objects (Assemblies, CLR-UDT, CLR-Store Procedure, CLR-Triggers)
Triggers (including DDL Triggers)
Synonyms
Schemas
File groups
Views (Including SCHEMA BINDING option)
Functions (Including SCHEMA BINDING option)
Store Procedures
Partition Functions
Users
Roles

Updated Wiki: Home

Grimpi — Wed, 30 Jul 2008 11:52:48 GMT

Project Description
Open 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
* XML Indexes
* XML Schemas
* User Data Types (UDT)
* CLR-User Data Types (CLR-UDT)
* Assemblys
* Triggers (including DDL Triggers)
* Synonyms
* Schemas
* FileGroups
* Views (Including SCHEMA BINDING option)
* Functions (Including SCHEMA BINDING option)
* Store Procedures
* Users
* Roles

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 more than 80 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.

UPDATED WIKI: Home

Grimpi — Sun, 16 Mar 2008 12:12:01 GMT

Project Description
Open DBDiff is a open source database schema comparison tool for SQL Server 2005. It reports any differences between two database schemas and provides a sincronized script to upgrade a database from one to the other.

Open DBDiff can sincronize
* Tables (including Table Options like vardecimal, text in row, etc..)
* Columns (including Computed Columns, XML options, Identitys, etc..)
* Constraints
* Indexes
* Data Types
* Triggers (incluiding 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 DMO.
We test this tools with almost 60 diferents 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.

UPDATED WIKI: Home

Grimpi — Fri, 14 Mar 2008 23:53:21 GMT

Project Description
Open DBDiff is a open source database schema comparison tool for SQL Server 2000/2005. It reports any differences between two database schema and provides a migration script to upgrade a database from one to the other.
You can also run the tool in command line.
I didn't found any tool like this open source for SQL Server.
We are working know to add MySQL 5.x in the proyect.

Additional information on starting a new project is available here: Project Startup Guide.