Cloud Training (Online)

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

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.