SQLDBCompare is a robust database schema/data 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 (tables, stored procedures, views and user defined functions), or the detailed level for individual object (show me).
• Comparison of total number of records in tables when their structures are identical (show me).
• User friendly color display system identifies database objects with different status when comparing them. You can tell an item as newly created, removed, or changed as well as the summary for all newly created, removed and changed items all by a quick glance (show me).
• User friendly color display system identifies line differences (added, removed, or changed) for individual database objects (show me).
• SQL syntax intellisense and intelliPrompt SQL Query Analyzer can help user sending query to both connected databases. User can do query without leave the application (show me).
• User can find corresponding comparing SQL objects quickly on other side by using "Search same object on other side" feature. (show me).

Powerful Data Record Comparison in Two Tables

• Data record comparison on two tables/views that either have identical structure or different structures. User can select comparing data records columns and column sorting orders (show me). The data comparison can be linked by all columns  or selected column(s). 
• User can compare two data sets groups that are defined in SQL statements (show me).
• User can compare two data sets groups that are defined in SQL statements on command line (show me).
• The data record comparing result of two tables displayed in an user friendly color display system. User can easily identify added, changed or removed records and a summary of total added, changed and removed records  (show me).
• User can view difference of two records or view the content of a record (show me).

Powerful Database Synchronization

• A reliable process that copy one or a group of database objects from one database to another (show me).
• Ability to copy all dependent SQL objects of selected SQL objects in the order of object dependency.
• Ability to move all data and preserve the identity field value when synchronizing table objects.