SQL Data Compare Release Notes

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

SQL Data Compare Release Notes

Postby richardjm » Mon Mar 03, 2008 9:48 am

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
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 395
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests