Open DBDiff for SQL Server 2008

Last few weeks , i have been playing around with this cool tool called Open DBDiff .

As the name suggests Open DBDiff tool lets you compare the database schema for SQL Server 2005 or SQL Server 2008  . Its a simple and effectve tool for database schema comparision .

Open DBDiff is a open source tool and reports differences between two database schemas and provides the SQL Script that synchronizes both databases so that you can use the SQL script to upgrade the database .

Open DBDiff can help you synchronize

  • 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

Download Open DBDiff for SQL Server 2008 here

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

One Response

  1. Manivannan April 23, 2015 Reply

Leave a Reply


x

Interesting BlogPosts to read

Column Alias and Square brackets in SQL Query.
When we want to specify a alias for a column in SQL Query , we tend to use the double quotes or sing...
How to get the MAX row with group by in LINQ query using C# ?
Below is a sample code snippet demonstrating how to retreive the max row with the group by in LINQ Q...
Webinar - The Shortcomings of SQL for SharePoint Sync
Redmond Magazine is hosting a webinar on the topic "The Shortcomings of SQL for SharePoint Sync" on ...