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.
• 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.
• Comparison of total number of records in tables when their structures are identical.
• 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.
• User friendly color display system identifies line differences (added, removed, or changed) for individual database objects.
• 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.

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.
• User can compare two data sets groups that are defined in SQL statements .
• User can compare two data sets groups that are defined in SQL statements on command line.
• 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.
• User can view difference of two records or view the content of a record.

Powerful Database Synchronization

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