SQL Compare

比較和同步 SQL Server 資料庫架構。

由以下開發商製作:Redgate Software
ComponentSource 開始代理銷售的日期:2005年

價格從： $ 311.85 版本: 15.3.x 新增功能 更新: Apr 9, 2024 5.00 評價的平均星級5.00 評價的平均星級5.00 評價的平均星級5.00 評價的平均星級5.00 評價的平均星級 (3)

SQL Compare 的螢幕截圖

SQL Compare 新版本發表

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...
閱讀詳情

Released: May 7, 2019

13.7.12 中的更新

Updates in 13.7.12

  • Fixed - Local objects that share the same name as a dependent object in another database are no longer seen as a dependency.
  • Fixed - SC-10496: Object existence checks no longer appear in the diff view when the "Add object existence checks" deployment option is enabled.
  • Fixed - Issues when running SQL Compare in a non-English locale, including SC-10487 where FILLFACTOR was ignored in scripts folders when running in a Turkish locale.

Released: Apr 29, 2019

13.7.11 中的更新

Updates in 13.7.11

  • Fixed - Error handling statements now in place between assembly drops to ensure we stop as soon as an error is encountered.
  • Fixed - SC-10477: We now deploy changes to partition schemes that are required by partition function changes, even if they would otherwise be ignored because the ConsiderNextFilegroup option is turned off.

Released: Apr 23, 2019

13.7.10 中的更新

特性

  • Role and user modifications will now usually be done within the transaction rather than beforehand (unless they must be done beforehand because of limitations of SQL 2005/8 or full text objects depending on them).
  • Partition Schemes now select their dependencies if Include Dependencies is specified and Ignore Filegroups is turned off. Table drops will generate a High warning if generated.