Lançamentos do SQL Compare
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...
Released: May 7, 2019
Atualizações na 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
Atualizações na 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
Atualizações na 13.7.10
Recursos
- 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
Atualizações na 13.6.14
Recursos
- Adds a new option to ignore sensitivity classifications on fields.
- Additional logging of .NET assembly loading to help investigate SDC-2906.
Correções
- 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...
