Total SQL Compare From Data to Schema

SQL Comparison Toolset

Version 7.1

  • Enhancements and bug fixes.

Version 7.0

  • Support for SQL Server 2016
  • New Schema Compare Options – SQL schema compare now supports several new compare options such as compare security policies, compare column master keys/encryption/mask, compare system versioning, compare hash index bucket count, and compare remote data archiving.
  • Command Line Wizard - Allows the user to create a command line xml file step-by-step, via a simple and intuitive interface.
  • New Data Compare Options – SQL data compare now supports several new compare options such as compare system versioned tables and compare stretched tables
  • Enhancements and bug fixes.

Version 5.0

  • Support for Microsoft Azure v11 and Microsoft Azure v12
  • Enhancements and bug fixes.

Version 4.1

  • New Ribbon Control - The new ribbon is organized exactly as the old one, so users who install the new version will not have trouble navigating it. There are some subtle differences:
    • The big button on the top-left corner has been removed, providing more space for the workspace or the comparison sessions.
    • The button that maximizes the workspace by hiding the ribbon is now part of the ribbon itself. It leaves the menu visible and hides the ribbon panels.
  • Entity Filters – Entity filters replace the previous schema filters. They affect only the schema compare and are supported by the UI and the command line. Users can access entity filters from the context menu of the comparison grid. The command line, on the other hand, provides three additional sample xml files that show the users how to use them.
  • Enhancements and bug fixes.

Version 4.0

  • Support for SQL Server 2014 - SQL Comparison Toolset now has support for SQL Server 2014
    • Memory optimized filegroups
    • Memory optimized tables
    • Hash and ranges indexes
    • Columnstore indexes
    • Memory optimized table types, including hash constraints and indexes
    • Natively-compiled stored procedures
    • Primary and secondary selective xml indexes
    • XML index namespaces and paths
    • New permissions and other minor enhancements introduced in SQL 2014
  • New Schema Compare Options – SQL Schema Compare now has the following new comparison options:
    • Compare Database filegroups - Indicates whether the filegroups, including the filegroup data files, should be compared and synchronized.
    • Compare memory-optimized tables - Indicates whether the memory-optimized tables should be compared and synchronized. This option is also available via the command line.
  • New Data Compare Options – SQL Data Compare now has the following new comparison options:
    • Compare and synchronize memory-tables - Indicates whether the data of memory-optimized tables should be compared and synchronized. This option is also available via the command line.
    • Compare and synchronize columnstore tables - Indicates whether the data of the tables with a columnstore index should be compared and synchronized. This option is also available via the command line.
  • Filegroup Mappings – The new Schema Compare filegroup mapping feature allows you to perform complex compares between databases with different filegroup structures. In addition, the following new filegroup options are now available:
    • Compare database filegroups, including filegroup data files.
    • Change the physical filename mapped to a data file directly in the comparison grid to overcome synchronization errors caused by the missing path of a data file on the target system.
    • Different mapping options when databases have different filegroup structures
    • Script or ignore the filegroup clause of database objects.
    • Mapping of the filestream filegroups independent from the regular filegroups.
  • Updated Workspace & Session User Interface – Several new workspace and UI enhancements are available including:
    • Improved performance
    • A consistent look & feel for both schema and data compare
    • A new color scheme that allows you to group and organize sessions by their similarities
    • New session execution count and sort order allows you to keep the most-frequently used sessions at the top of the workspace.
    • A new tab that lists snapshots separate from live database for improved navigation.
  • Enhancements and bug fixes

Version 3.1

  • Schema compare now has support for the database COMPATIBILITY level. When the SQL Server compatibility is set to a previous version of the database, Schema Compare will now generate a script appropriate for that version.
  • Data or Schema Compare workspaces can now be saved to a custom location.
  • Data Compare now has a new option to compare SQL Server system databases, such as master, model, msdb or tempdb.
  • Data Compare has a new option to change the location where the temp data is kept during the data comparison.
  • It is no longer necessary to install the SQL Toolbox framework prior to installing SQL Comparison Toolset

Version 3.0

  • Newly Redesigned Schema Compare User Interface – A new streamlined and more intuitive user interface includes an improved comparison grid with grouping, filtering and search capabilities, as well as an enhanced script difference view
  • New Schema Compare Database Object Support – SQL object compare includes CLR objects and user defined table types so users can customize which objects should be included in a database comparison
  • New Schema Compare Comparison Options – SQL object compare now supports several new object compare options that enable users to customize which objects for properties should be ignored or included during schema comparisons
  • New Schema Compare Synchronization Script Options – Specify whether selected Object Compare settings and options should be scripted and included in the synchronization script
  • New Data Compare Synchronization Script Execution Options – SQL object compare now has several new options to control the execution of the synchronization script, such as continuing script execution on error or setting the maximum transaction size
  • One Click Operations – SQL schema comparison sessions are now saved in the workspace, including all of the data relating to the comparison operations, such as the databases, credentials, compare, scripting and execution options and more
  • Full Support for SQL Server 2012 – SQL schema compare now contains full support for SQL Server 2012 including new objects
  • Asynchronous Comparison Operations – SQL schema compare operations are now performed asynchronously
  • Enhanced Logging – SQL schema compare now has enhanced logging for API errors, UI errors and script execution

Version 2.1

  • Support for SQL Server 2012
    • Object comparisons of tables now complete without error when tables include either a check constraint or default constraint that depends on user-defined functions
    • The data compare command line now properly parses the ForeignKeyAction option
    • Data comparisons no longer incorrectly flag rows as different when the first column of the data candidate keys (primary key, unique constraint, or unique index) is created as a DESCENDING column
    • Data compare synchronization scripts now execute properly when:
      • Unique keys defined on columns allow NULL values
      • Varbinary(max) columns were created with FILESTREAM attribute
  • Data compare now properly handles licensing on Windows configurations that enforce FIPS-compliant cryptography algorithms
  • Fixes to object compare snapshots
  • SQL Server 2012 Testing Compatibility: SQL comparison toolset 2.1 is SQL Server 2012 RC0 compatible in non-production environments

Version 2.0

  • Completely Redesigned Console – New user interface design and navigation to maximize user productivity
  • Expanded Comparison Options – Perform granular comparisons with new comparison options such as comparing and synchronizing views along with tables, comparing databases with different collation, variable transaction size, and many more
  • New Comparison Sessions – Easily repeat frequent compare operations with one simple click using comparison sessions which contain all the data related to a comparison operation including databases, credentials, comparison options, mapping rules, and excluded objects
  • Customizable Mapping Rules – Easily customize the way database objects are mapped together using new schema, name, and data mapping rules
    • Enhanced support for comparing large databases – Enhanced memory utilization, custom algorithms, and a new user interface improve the performance when comparing large databases
    • Improved Error Handling – Improvements to the error handling allow for non-critical errors to be logged without stopping the data operations. A full error log is created and saved for review and analysis
    • Enhanced data handling – Idera SQL data compare now uses SQL native types instead of .NET types to read the data from SQL Server databases which provides faster read time and mirror database types
    • Improved Scripting – Idera SQL data compare has improved scripting of binary fields and large text fields

Version 1.4

  • Enhancements and bug fixes

Version 1.3

  • Windows 2008 R2 and Windows 7 support
  • SQL Server 2008 R2 support

Version 1.2

  • Enhancements and bug fixes
No credit card required! Fully functional for 14 days HeroImage

Buy Now

Includes first year of maintenance.

Add to Cart

Buy online now and save 40% Use code SQLCMP40 at checkout

Request a Quote

Live product Demo

See SQL Comparison Toolset in action with a seasoned pro.

Request a Demo