SQL Compare Pro

Compare and synchronize SQL Server database schemas.

Published by Redgate Software
Distributed by ComponentSource since 2005

Version: 14.9.x Updated: Aug 10, 2022

Screenshot of 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 Releases

Released: Aug 27, 2019

Updates in 13.8.0

Fixes

  • 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...
Read more

Released: Aug 12, 2019

Updates in 13.7.22

Fixes

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

Released: Jul 31, 2019

Updates in 13.7.21

Fixes

  • 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

Updates in 13.7.20

Fixes

  • 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

Updates in 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

Updates in 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

Updates in 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

Updates in 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

Updates in 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

Updates in 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...
Read more