webequ.in   Home

CompareDBs

CompareDBs is a free tool for Windows that compares two SQL Server database schemas, produces a visual display of the differences, and lets you selectively change the databases so that they match.

CompareDBs has been tested with SQL Server 2000 and 2005.

Download

• Download CompareDBs 1.1.0.1 (200 KB) - requires .NET Framework 1.1.

Features

• Compare the tables and columns in two databases.
• Compare columns' data types, default values, maximum lengths, and nullabilities.
• Examine a visual display of the differences, or copy them to the Clipboard.
• Eliminate differences by right-clicking them and choosing a suggestion (requires SQL Server 7.0 or higher).
• Smooth background execution with a progress bar.

Limitations

These may be fixed in future versions.

• Copying a table copies the identity column and primary key, but ignores any foreign key constraints.
• CompareDBs does not compare stored procedures, triggers, or constraints (other than default values). For stored procedures, consider Stored Procedure Batch Update.

Settings are saved to a file, Settings.dat, in the same folder. This includes the last two connection strings in plain text. If you don't want this information saved, create an empty Settings.dat file that is read-only.