Rilasci di SQL Compare

Released: Jul 15, 2019

Aggiornamenti 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

Aggiornamenti 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

Aggiornamenti 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

Aggiornamenti 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

Aggiornamenti 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

Aggiornamenti 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...

Released: May 7, 2019

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

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

Aggiornamenti in 13.7.10

Funzionalità

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

Released: Feb 4, 2019

Aggiornamenti in 13.6.14

Funzionalità

  • Adds a new option to ignore sensitivity classifications on fields.
  • Additional logging of .NET assembly loading to help investigate SDC-2906.

Correzioni

  • SC-10397: SQL Compare now sets the correct value for NATIVE_COMPILATION when reading from a scripts folder.
  • SC-10398: Fixed a snapshot deserialization crash for case differences in column names between temporal and history tables.
  • SC-10402: Dropping temporal tables with columns that depend on a user defined type no longer throw an...