SQL Compare Releases
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...
Released: May 7, 2019
Updates 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
Updates 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
Updates in 13.7.10
Funktionen
- 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
Updates in 13.6.14
Funktionen
- Adds a new option to ignore sensitivity classifications on fields.
- Additional logging of .NET assembly loading to help investigate SDC-2906.
Fehlerkorrekturen
- 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...
Released: Oct 15, 2018
Updates in 13.6
Funktionen
- SQL Compare now supports comparison and deployment of sensitivity classifications
- SQL Data Compare options can now be specified with the /datacompareoptions switch when deploying static data through the SQL Compare command line.
Fehlerkorrekturen
- SC-10264: User defined types that are dependencies will no longer be deployed if the option to include dependencies is not set.
- The DataFileSet node of the RedGateDatabaseInfo.xml file in a scripts folder has been deprecated and no longer...
Released: Sep 17, 2018
Updates in 13.5
Funktionen
- Added support for using SQL Change Automation projects as a data source in SQL Compare.
Fehlerkorrekturen
- A create index statement with a string literal as a filegroup name will no longer cause a parser error.
- Fixed the sca2 command-line parameter not being recognised.
- SQL Compare no longer explicitly deploys default data spaces.
- SQL Compare command line no longer normalises all line endings to CRLF when adding static data.
Released: Jan 30, 2018
Updates in 13.1.10
Funktionen
- Handles filegroups defined on a fulltext index.
- Handles user defined and customized history tables for temporal tables, and will store all history tables in scripts folders.
- Integrates the Redgate bulk uninstaller.
- SQL Compare Command Line now runs in 64-bit mode by default.
Fehlerkorrekturen
- SQL Compare no longer displays a blank warning dialog when asking to overwrite the existing comparison report
- SQL Compare doesn't duplicate index creation on history tables.
- SQL Compare can...
Released: Oct 30, 2017
Updates in 13.1.x
Funktionen
- Improved logging capabilities
- SQL Compare now generates a new style of HTML report, to match the reports produced by other Redgate products.
Fehlerkorrekturen
- SC-9781: SQL Compare can deploy temporal tables from a scripts folder to a live database.
- SC-8880: Scripts folders can now be in the root of a drive (as long as it is otherwise empty)
- SC-9775: On the command-line, in the absence of a
-reporttype switch, SQL Compare now correctly uses the -report switch to infer the report type...
