SQLDBCompare is a robust database schema comparison and synchronization tool for SQL Server databases. It provides you great ease and productivity to manage SQL Server database development and production maintenance, more specifically:

Full Database Schema Comparison for SQL Server Database

• Database comparison that covers all major SQL Server database objects including stored procedures, tables, user defined functions, and views. (show me)
• Database schema comparison at either the high-level for entire database or the four object types mentioned above, or the detailed level for individual object (show me)
• Comparison of total number of records in tables when their structures are identical. (show me)
• An intellisense-style color display system identifies database objects with different status when comparing them. You can tell an item as newly created, removed, or changed, all by a quick glance. (show me)
• An intellisense-style color display system identifies line differences (added, deleted, or changed) for individual database objects. (show me)

• A reliable process that copy the database object from one database to another.
• Ability to move all data and preserve the identity field value when synchronizing table objects.