SQL Compare Pro（英語版）

SQL Serverデータベーススキーマの比較と同期

Redgate Software 社の製品
2005 年より日本国内にてComponentSourceで販売中。

バージョン: 14.9.x 更新日: Aug 10, 2022

SQL Compare Pro（英語版） のスクリーンショット
i

SQL Compare Pro and SQL Compare Standard are no longer available. Instead Redgate offer a single offering; SQL Compare now available as a subscription license.

SQL Compare Pro のリリース

Released: Aug 27, 2019

13.8.0 での更新項目

不具合の修正

  • SC-10625 - CONCAT_WS is now recognised as a system function on SQL Server 2017 and above.
  • SC-10644 - The 'drop and create instead of alter' option has been renamed 'use drop and create for rerunnable scripts' and had the 'drop and create instead of create' functionality restored. It still only works on some object types, which are listed in the option description.
  • SC-10641 - text objects (e.g. stored procedures) that reference system queues no longer cause a crash in dependency processing...
続きを読む

Released: Aug 12, 2019

13.7.22 での更新項目

不具合の修正

  • SC-10604: Option text for Ignore Indexes updated to reflect operation of this option with a script folder target.

Released: Jul 31, 2019

13.7.21 での更新項目

不具合の修正

  • Compare will now not drop foreign keys on unselected tables when Include Dependencies is off, even when this will cause the database to be left in an inconsistent state / the deployment script to fail.

Released: Jul 29, 2019

13.7.20 での更新項目

不具合の修正

  • Prevented a hard crash (stack overflow) when parsing very complex constraints, defaults and computed columns. A log error will be recorded if this happens.
  • Fixed a crash when SQL contains hundreds of nested parentheses.

Released: Jul 15, 2019

13.7.18 での更新項目

Updates in 13.7.18

  • Fixed: ANSI current_timestamp syntax now reads correctly from scripts folder.
  • Fixed: Warning added for downgrade of AUTO_GRID tesslation schemes in spatial indexes.
  • Fixed: Compare now correctly parses the case where you have both an XML NAMESPACES and a CTE in a cursor declaration within a stored procedure.

Released: Jul 8, 2019

13.7.17 での更新項目

Updates in 13.7.17

  • SC-10528: Improved performance calculating work when many default constraints are present.
  • SC-10562: Improved error message when your scripts folder contains a field with an invalid data type.
  • Impersonate permissions on roles and schemas now deploy correctly.
  • Old (pre-v13) snapshots should now load quicker.

Released: Jun 13, 2019

13.7.16 での更新項目

Updates in 13.7.16

  • Fixed a bug where necessary whitespace would sometimes not be included in the migration script when renaming a table which is referenced in a procedure.
  • Synonym dependencies behaviour has changed.
  • SC-10524: SSMS 18 now correctly listed in application options.
  • Text object dependencies can now disambiguate between types and tables with the same name.

Released: Jun 6, 2019

13.7.15 での更新項目

Updates in 13.7.15

  • SC-10531: Comparing two different Git revisions using the SQL Compare command line now works.
  • SC-10516: Columnstore index columns can no longer incorrectly be marked as DESC.
  • SC-10510: Updating a scripts folder when the only change is alters to XML schema collections now works.

Released: Jun 3, 2019

13.7.14 での更新項目

Updates in 13.7.14

  • Fix: Error handling statements added between route drop, XML schema collection drop/unbind and view refresh statements.
  • SC-10528: Corrected a performance issue when comparing default constraints.
  • SC-10519: Backups created with SQL Backup using multiple threads and with CHECKSUM enabled are now supported.

Released: May 13, 2019

v13.7.13 での更新項目

Updates in 13.7.13

  • Fixed:
    • SC-10455: Scripts folder deployments now restore pre-existing permissions if Ignore Permissions option is set.
    • SC-10505: Fixed an issue parsing stored procedures preceded by a nested comment, that could result in an a crash, or an incorrect diff being shown when the "Ignore authorization on schema objects" option is set.
    • Ignore SET QUOTED_IDENTIFIER and SET ANSI_NULLS option now also removes those from the initial SET statement, and additionally removes the deprecated...
続きを読む