Developping for the translation industry RSS 2.0



 Thursday, 04 December 2008

Open DBDiff is an open source database comparison tool for SQL Server 2005 that generates synchronization SQL. It has options to customize the comparison and SQL generations. The database differences are identified at a high level. The synchronization SQL it generates can be copied to a query tool to be executed after you review it.

Open DBDiff can synchronize:

  • Tables (including Table Options like vardecimal, text in row, etc.)
  • Columns (including Computed Columns, XML options, Identities, etc.)
  • Constraints
  • Indexes
  • XML Indexes
  • XML Schemas
  • User Data Types (UDT)
  • CLR-User Data Types (CLR-UDT)
  • Assemblies
  • Triggers (including DDL Triggers)
  • Synonyms
  • Schemas
  • File groups
  • Views (Including SCHEMA BINDING option)
  • Functions (Including SCHEMA BINDING option)
  • Store Procedures
  • Users
  • Roles

When you are using such tools, always remember to double check the generated SQL script for anything suspicious that may harm your environment.

OpenDBdiff2

 

Other posts:

Free software tools for students

My 6 favourites file hosting services

Tools for web developers

Tool of the day: Copy source as HTML

Thursday, 04 December 2008 09:58:23 (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
SQL | Tools

Navigation
Advertisement
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2017
Stanislas Biron
Sign In
Statistics
Total Posts: 135
This Year: 0
This Month: 0
This Week: 0
Comments: 1
All Content © 2017, Stanislas Biron