SQL comparison toolset v2.1
SQL Server object and data comparison
| |
|
Quickly identify and synchronize data and object changes
- Perform SQL data compare and SQL schema compare tasks and synchronization
- Capture schema snapshots to preserve change history
- Synchronize SQL data automatically via command-line
- Customize environment using workspaces and saved comparison options
- Support SQL Server 2000, 2005, 2008, 2008 R2, 2012
|
|
|
|
|
New in Version 2.1.2
- Support for SQL Server 2012
- Enhancements and bug fixes
- 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.
New in Version 2.1.1
- Fixes to object compare snapshots
New in Version 2.1
- SQL Server 2012 Testing Compatibility: SQL comparison toolset 2.1 is SQL Server 2012 RC0 compatible in non-production environments.
- Updated license key activation service
New in 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.
- Enhancements and bug fixes
- 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, but not stop 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.
New in Version 1.4
- Enhancements and bug fixes.
New in Version 1.3
- Windows 2008 R2 and Windows 7 support
- SQL Server 2008 R2 support
New in Version 1.2
- Enhancements and bug fixes.