Oct 282014

This is the continuation of the previously written post. Open DBDiff Open DBDiff is a free and 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, [… read more]

May 052012

Transactions are an integral part of any (serious) database development when there is need for data consistency. Transactions in a database environment have two main purposes: To provide reliable mechanism to allow correct recovery from failures and keep a database consistent To provide isolation between programs accessing a database concurrently. It’s impossible to mention transactions without mentioning the ACID (Atomic, Consistent, Isolated and Durable) attributes [… read more]