SQL Accord - Bringing Ease to DBAs and Developers Everywhere...   

Are you looking for an easy way to do SQL Server database compares? SQL Accord is the clear choice if ensuring database consistency is an important part of your job. If you need performance for very large databases, coupled with an intuitive environment specifically designed to assist you in getting the job done quickly and easily - this full featured tool belongs in your toolbox. Throw away your old inadequate "DB Compare" SQL script and try this modern tool.

There are three editions of SQL Accord. The MS Edition provides advanced support for Microsoft SQL Server, the free CE Edition provides basic schema compare functionality for Microsoft SQL Server, and the ASE Edition provides support for Sybase Adaptive Server Enterprise (ASE).

MS Edition - Full Support for Microsoft SQL Server  [Download Now]

• All recent versions supported: 7.0, 2000, 2005, MSDE
• Tables (Primary Keys, Foreign Keys, Indexes, Columns, Row Count, Max Width, Triggers)
• Views (Columns, Definitions with drill-down for Side by Side SQL Text Comparison)
• Stored Procedures (Parameters, Definitions with drill-down for Side by Side SQL Text Comparison)
• Functions (Parameters, Definitions with drill-down for Side by Side SQL Text Comparison)
• Users and Roles (Names, Membership, Permissions)
• UDDTs (User Defined Data Types)

CE Edition - Robust Schema Compare Functionality for Microsoft SQL Server  [Download Now]

• 100% Free - no strings attached!
• Same comparison features and functionality as the full MS Edition
• No support for Command Line, Reports or Exports

ASE Edition - Full Support for Sybase Adaptive Server Enterprise (ASE) [Download Now]

• All recent versions supported: 11.0.x, 11.5.x, 11.9.x, 12.0.1, 12.5.x, 15
• Tables (Primary Keys, Foreign Keys, Indexes, Columns, Row Count, Max Width, Triggers)
• Views (Columns, Definitions with drill-down for Side by Side SQL Text Comparison)
• Stored Procedures (Parameters, Definitions with drill-down for Side by Side SQL Text Comparison)
• Functions (Parameters, Definitions with drill-down for Side by Side SQL Text Comparison)
• Users and Groups (Names, Membership, Permissions)

Flexible Object Comparison Selections

• Ability to choose any single object by name, any set of selected objects, none or all objects of a given type for comparison. This allows you to compare a single database table, or perform a compare of an entire SQL Server Schema.

Tunable Comparison Criteria

• Ability to determine which attributes of a SQL object type are to be included in the comparison
• Comparison Criteria selections are Session specific and are saved and re-loaded as part of the Session file
• Ability to ignore or include carriage returns, and/or spaces, and/or tabs when comparing text based SQL objects such as stored procedures

Advanced Integration Capabilities (not available in Community Edition)

• Robust Command Line Interface (CLI). You can reference a session file allowing you to easily control numerous configuration options easily from the command line.
• Silent (UI-Less) mode
• Ability to export results in several different formats: XML, HTML, RTF, Excel, PDF

High Performance Comparison

• SQL Clarity's HyperDiff technology zings through small databases almost instantly, and powers through verly large databases in only a few minutes
• Large databases (500+ tables, 1000+ stored procedures) typically take less than five minutes to compare across a network in a typical environment with modern hardware
• Phased Operation focuses data gathering on only one server at a time, instead of both servers simultaneously, in order to minimize the time-span of comparison impact against each server
• Status indicators keep you informed of comparison progress

Powerful and Flexible Results Presentations

• Differences Tree - a simple hierarchical representation showing only differences
• Side by Side Tree - a color coded synched hierarchical view showing all objects and their comparison status
• Diferences Report- a formatted report allows you to print the results (Not available in Community Edition)
• Details panel shows context sensitive information regarding the selected item, and may include links for drill down
• Syntax Highlighted drill down view of text based SQL objects, such as stored procedures, views, and triggers
• Side by Side text based drill down compariison view of differing SQL objects - to pin-point exact differences in code in stored procedures, views, triggers and functions.
• Side by Side text difference comparison is facilitated with the free text diff tool ExamDiff ( see Presto Software for information), bundled and installed with the product. SQL Accord can be configured to use any other text diff tool with a command line interface.