SQL Compare

比较和同步 SQL Server 数据库架构。

由以下开发商制作:Redgate Software
ComponentSource开始代理销售的日期:2005年

价格从： US$ 323.73 版本:16.0.x 新增功能 更新: Jun 18, 2026 5.00评价的平均星级5.00评价的平均星级5.00评价的平均星级5.00评价的平均星级5.00评价的平均星级 (3)

SQL Compare 屏幕截图

SQL Compare 新版本发表

Released: Mar 4, 2021

14.5.x 中的更新

v14.5.22.19589

Updated Aug 16, 2021

Fixes

  • Fixed broken table renaming technique.

v14.5.21.19562

Updated Aug 9, 2021

Fixes

  • Internal library updated.

v14.5.19.19515

Updated Jul 26, 2021

Features

  • Improved performance when reading from backup files.

v14.5.18.19506

Updated Jul 22, 2021

Fixes

  • Fixed error 'field change calculation failed in TableRebuildChecker' when deploying in certain mapping scenarios.

v14.5.17.19461

Updated Jul 19, 2021

Features

  • Internal library updated.

v14.5.16.19388

Updated Jul...

阅读更多

Released: Aug 24, 2020

14.4.x 中的更新

v14.4.23.18321

Updated Feb 22, 2021

Fixes

  • ZD-245196: Deploying a full text catalog along with its owner will no longer duplicate the CREATE USER statement.
  • SC-10963: The /makescripts option on the command line no longer writes out migration blocks metadata for non-migration blocks databases.

v14.4.22.18256

Updated Feb 15, 2021

Fixes

  • SC-10959: SQL Compare now properly handles temporal tables on partition schemes.

v14.4.21.18202

Updated Feb 8, 2021

Fixes

  • Internal library updates.
阅读更多

Released: Jul 20, 2020

14.3.x 中的更新

14.3.4.16598

Updated Aug 19, 2020

Fixes

  • Fixed "Multi-module assemblies are not supported when loading from memory".

14.3.3.16559

Updated Aug 11, 2020

Fixes

  • Internal library updates.

14.3.2.16501

Updated Jul 30, 2020

Fixes

  • The current highlighted row in the differences grid is deselected (de-highlighted, not unticked.) after a refresh.
  • SC-10890: Azure AD users are now registered on an Azure SQL database.
  • SC-10891: When generating a script for a partition scheme change, an exception is no longer...
阅读更多

Released: Jan 29, 2020

14.2.x 中的更新

14.2.19.16383

Updated Jul 13, 2020

Fixes

  • Internal library updates.

14.2.18.16317

Updated Jul 6, 2020

Fixes

  • SC-10865: Fixed the filter pane behavior when changing All Object Types.

14.2.18.16251

Updated Jun 29, 2020

Fixes

  • SC-10852: Fixed SQL Server version not being read from SSDT/SCA project file.
  • SC-10853: When rebuilding an index, the order of included columns is now respected.
  • ZD160360: Fixed an occasional hang when comparing CLR assemblies.

14.2.17.16188

Updated Jun 23, 2020

Fixes

  • SC-...
阅读更多

Released: Oct 28, 2019

14.1.x 中的更新

14.1.10.14805

Updated Jan 27, 2020

Fixes

  • Changing a column from a user defined type and simultaneously dropping that user defined type no longer attempts to rebind the type after dropping it.
  • Create Partition Scheme statements in scripts folders which contain too many filegroups for their partition function will now be read in as SQL Server does, i.e. the excess filegroups will be ignored.
  • Permissions on the 'dbo' special user are now registered correctly.
  • The null unicode character no longer...
阅读更多

Released: Sep 9, 2019

14.0.x 中的更新

14.0.7.13517

Updated Oct 21, 2019

Fixes

  • SC-10677: Now avoids stack overflow with heavily nested computed columns more stringently. Some computed columns may show a syntax-only difference between live and scripts databases if they couldn't be parsed; this can be fixed by deploying the live version to the scripts folder.
  • SC-10666: The IsSQLCloneDatabase extended property no longer appears in comparisons, so that it can't be accidentally deployed to non-clone databases.
  • SC-10682: Sorting the grid...
阅读更多

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.