SQL Compare のリリース

Released: Oct 16, 2017

13.0.x での更新項目

機能

  • SQL Compare now requires .NET 4.6.1.
  • Improved the installer UI for SQL Compare.
  • SQL Compare now supports altering SQL Server 2017 graph tables.
  • SQL Compare now deploys SQL Server 2017 graph tables declared with AS NODE or AS EDGE.
  • SQL Compare now appends a logging statement at the end of the deployment script to log the deployment details to SQL Server Log in order for SQL Monitor to detect the deployment and mark it on the timeline for performance data. Note that this feature is currently in...

Released: May 16, 2017

12.4 での更新項目

機能

  • Summary view of detailed differences - New summary view, which lists the semantic differences between two tables now makes it easier to understand why two objects are different.
    This will help people in situations where the SQL diff isn't representative of the differences between two objects, for example:
    • When comparing tables without the "force column order" option.
    • When comparing different database versions so a constraint is inlined on one side and not the other.
    • When ignoring names of...

Released: Mar 27, 2017

12.2 での更新項目

機能

  • SQL Compare now supports temporal tables on SQL Server 2016.
    • Include temporal tables when deploying changes and comparing differences to your SQL Server databases.
    • See what’s changed in your current table, plus what will be added to the history table.
    • When you are ready to deploy, the script will include the expanded temporal table.
  • New warning message lets you know if you are deploying to an older version of SQL Server that doesn’t support temporal tables.
  • The My Projects dialog will now...

Released: Sep 19, 2016

12.0 での更新項目

機能

  • New User Interface (UI) - Overhauled UI of SQL Compare aligns with Redgate's new common design guidelines. Improves the underlying codebase and fixes over 200 UI related bugs.
  • Parallel registration - When registering from a live database, scripts folder, or a snapshot, SQL Compare will now register both data sources at the same time, rather than waiting for your source to finish before starting on the target. This should speed up the comparison considerably.
  • Login based licensing - SQL...

Released: Jul 18, 2016

11.6 での更新項目

機能

  • Now accepts the ALTER DATABASE CURRENT syntax.
  • Now connects to SQL Server 2016 RTM.
  • New product switcher - accessible from the product logo top-left.
  • Now deploys migrations created in SQL Source Control 5 Release Candidate.
  • Migrations created with the SQL Source Control 5 Beta are no longer supported.

不具合の修正

  • SC-8668: SQL Compare no longer generates incorrect creation script for objects using WITH ENCRYPTION option when AS keyword not specified.
  • SC-8421: Dependencies now correctly calculated...

Released: Mar 21, 2016

Updates in this release

Updates in 11.5

New Features

  • SQL Compare now connects to SQL Server 2016 RC0.
  • SQL Compare now has a SHA-256 digital signature.
  • SQL Compare now reads tables and indexes more quickly, especially those in schemas with many partitions. Applies to SQL Server 2005 and onwards, as well as Azure V12.

Fixes

  • SC-7985: SQL Compare no longer errors on registration when attempting to decrypt objects on low compatibility level databases.
  • SQL Compare no longer adds some blank lines or redundant GOs when...

Released: Jan 10, 2012

Updates in this release

Updates in 10.0

  • Table mapping - Map together tables and columns with different names; this can be useful to prevent data loss when deploying tables or columns that have been renamed.
  • Creating a new database to compare - Useful if you want to create a copy of the source database.
  • Comparing revisions from SQL Source Control - Select specific versions of a source-controlled database to compare.
  • New command line switches - AbortOnWarnings, IgnoreSourceCaseSensitivity, LogLevel, ShowWarnings...

Released: May 19, 2011

Updates in this release

Updates in 9.0

  • SQL Compare 9.0 now supports SQL Azure databases.
  • Various bug fixes

Released: Feb 11, 2011

Updates in this release

Updates in V8.5

  • A free add-in for SQL Server Management Studio that enables you to set data sources to compare and synchronize from within SQL Server Management Studio
  • Fast deployment and Fast deployment projects: synchronization with one click (Pro feature)
  • Support of handling databases under SQL Source Control (using the add-in)

Released: Sep 24, 2010

Updates in this release

Updates in V8.2

SQL Compare 8.2 is a minor release, including a number of bug fixes.

  • Better handling of encrypted objects
  • SQL Compare now correctly synchronizes the user permission: View Change Tracking
  • The command line interface now correctly displays script parser errors
  • The command line interface now displays a synchronization script correctly when synchronizing two scripts folders
  • The interactive HTML report can now be viewed without an Internet connection
  • Other minor user interface issues