What is SQLDBCompare?
SQLDBCompare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. SQLDBCompare integrates with SQL Server, providing an effective and effortless database schema comparison for individuals and project teams to compare the SQL Server databases on either the same server or different servers. It also provides the functionality for developers to synchronize the SQL Server objects from one database to another.
With SQLDBCompare, users can compare database structure/schema/table records over database objects (tables, stored procedures, user defined functions, views, triggers, indexes/keys, and constraints) in two databases. User can view the results at a high-level, or drill down to the fine grains of every detail for each difference. The users can synchronize each database object by copying the object (structure) from one database to another. It supports both SQL Server 2000 and SQL Server 2005.

Who needs SQLDBCompare?
Any project team or DBA's managing multiple copies of the same database on SQL Server. If you have various database environments such as development, test, staging, and production, or distributed SQL Server databases where schema/code updates to each database can occur at a different time, SQLDBCompare is the right tool that you have been looking for!