SQL Compare Pro

Compare e sincronize esquemas de bancos de dados SQL Server.

Publicado por Redgate Software
Distribuído pela ComponentSource desde 2005

Versão: 14.9.x Atualizado: Aug 10, 2022

Captura de tela do 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.

Lançamentos do SQL Compare Pro

Released: Aug 27, 2019

Atualizações na 13.8.0

Correções

  • 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...
Leia mais

Released: Aug 12, 2019

Atualizações na 13.7.22

Correções

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

Released: Jul 31, 2019

Atualizações na 13.7.21

Correções

  • 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

Atualizações na 13.7.20

Correções

  • 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

Atualizações na 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

Atualizações na 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

Atualizações na 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

Atualizações na 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

Atualizações na 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

Atualizações na 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...
Leia mais