SQL Data Compare Release Notes

richardjm

SQL Data Compare 6.1.1

This is a minor update to 6.1.0 and fixes issues with the commandline and backup before synch.

It is advised to un-install version 6.1.0 before installing 6.1.1.

Users upgrading from version 6.0.0 to 6.1.1 need not un-install.

SQL Data Compare 6.1.0

What’s new in 6.1

• Speed improvements when comparing to backups
• Option to compress temporary files
• Ability to filter tables and views in the project configuration
• Usual selection of bug fixes

SQL Data Compare 6.0

What’s new in 6.0

• Compare to backup (SQL Backup 3,4 or 5 or SQL Server Native) – this is a ‘Pro’ feature
• Pivot view – alternative table differences visualization
• Backup before synch (SQL Backup 4 or 5 or SQL Server Native)
• Improved differences navigation
• Per-table synchronization SQL
• Project settings are not lost when schema is changed
• Projects are not saved automatically
• Reseed identity column
• Use ‘force binary collation’ for case sensitive comparisons
• Filter tables in comparison results
• Set WHERE clauses on multiple tables at once

SQL Data Compare 6.0 will work alongside previous versions without problems. You will also get a new 14 day trial period to try it out.

We have stopped supporting SQL Server 7 for this version. You will need to have .NET 2.0 installed for this version to work.

SQL Data Compare 5.3

The following issues were addressed

SQL Compare/SQL Data Compare/SQL Packager /Dependency Tracker

Vista support SQL Bundle Installer now supports Running installer in quiet mode

SQL Compare

Improved support of non-compliant assemblies Improved .NET2 Snapshots with XML Schema Collections Improved Dependency calculating in Synchronization Support for multiple column INCLUDEs in INDEX es

SQL Data Compare

Improved support for Scripts created as Unicode when non-Latin collation Improved support for Foreign keys (now recreated with SET NULL or SET DEFAULT)

CommandLine:

Fully qualified names now used when specifiying table names for indexes and columns

SQL Data Compare 5.2

The following issues were addressed
SQL Compare 5.2

Fixed problem when reading case-sensitive computed columns Fixed scripting issue when attempting to revoke permissions on newly built function Fixed "Specified Cast is not valid" exception when users do not have full permissions Fixed problem where occasionally an "index outside the bounds of the array" exception was thrown when reading CLR objects Fixed problem where if the “ignore constraint and index names” option was enabled objects could be missing from the synchronisation Fixed problem where if a constraint’s object text was greater than 4000 characters a duplicate object would be detected. TYPE COLUMN options now work correctly with varbinary(max) Calls to sp_addrolemember are now unicode compliant Context sensitive help nolonger throws an unhandled exception when running under .NET2 Fixed problem where SQL Compare attempted to generate XML indexes on SQL2000 databases

SQL Data Compare 5.2

Fixed problem with UDTs and Indexed views SQL Data Compare now no longer attempts to do invalid casts of alias types

SQL Packager 5.2

Updated help SQL Packager no longer includes data when the table schema is deselected Indexed Views are now displayed correctly Fixed problem when loading an old project, deselected tables were reselected It is now possible to disable the "Include Indexed views" option Added basic support for pre & post SQL scripts

Other

Added extra SQL Data Compare samples to C#/VB

SQL Data Compare 4.0

Features include:

- Full SQL Server 2005 support
- Improved dependency algorithm
- Performance enhancements