Rilasci di SQL Compare
Released: Oct 28, 2019
Aggiornamenti in 14.1.x
14.1.10.14805
Updated Jan 27, 2020
Fixes
- Changing a column from a user defined type and simultaneously dropping that user defined type no longer attempts to rebind the type after dropping it.
- Create Partition Scheme statements in scripts folders which contain too many filegroups for their partition function will now be read in as SQL Server does, i.e. the excess filegroups will be ignored.
- Permissions on the 'dbo' special user are now registered correctly.
- The null unicode character no longer...
Released: Sep 9, 2019
Aggiornamenti in 14.0.x
14.0.7.13517
Updated Oct 21, 2019
Fixes
- SC-10677: Now avoids stack overflow with heavily nested computed columns more stringently. Some computed columns may show a syntax-only difference between live and scripts databases if they couldn't be parsed; this can be fixed by deploying the live version to the scripts folder.
- SC-10666: The IsSQLCloneDatabase extended property no longer appears in comparisons, so that it can't be accidentally deployed to non-clone databases.
- SC-10682: Sorting the grid...
Released: Aug 27, 2019
Aggiornamenti in 13.8.0
Correzioni
- 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...
Released: Aug 12, 2019
Aggiornamenti in 13.7.22
Correzioni
- SC-10604: Option text for Ignore Indexes updated to reflect operation of this option with a script folder target.
Released: Jul 31, 2019
Aggiornamenti in 13.7.21
Correzioni
- 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
Aggiornamenti in 13.7.20
Correzioni
- 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
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.
