SQLDBCompare 2.4

SQLDBCompare is the powerful database schema comparison and synchronization application 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. The users can synchronize each database object by copying the object (structure) from one database to another.

Who needs SQLDBCompare?

Any project team or DBAs 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!


Here are some key features of "SQLDBCompare":

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.
· 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.