SQL Compare Pro
比較和同步 SQL Server 資料庫架構。
由以下開發商製作:Redgate Software
ComponentSource 開始代理銷售的日期:2005年
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...
