CompareDB can help you in the following situations:

find the differences between the development and production databases
find the difference between two versions of you database
automize the upgrade procedure
double-check the database creation script

CompareDB compares and syncronizes the following database objects:

Tables
View
Stored procedures
Functions
Triggers
Relationships between objects

CompareDB currently supports the following databases:

Microsoft SQL Server 2000
MSDE
Microsoft SQL Server 2005
Microsoft SQL Server 2005 express

How the database structure comparison work:

Specify the two databases to compare
Specify what type of objects to compare
CompareDB reads the structure of the two databases
CompareDB compares the structures and displays the results

How the syncronization procedure work:

Specify the direction of the syncronization (make the database on the left side same as the one on the right side or vice versa)
CompareDB generates the syncronization script and displays it
You can choose to save the script or continue with the automatic execution of the script
CompareDB either saves the script or automatically executes it depending on you option.