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 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. It also can compare data records in two tables at user specified columns and sort order. 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.