SQL Data Compare 16.0 release notes
Published 10 December 2025
What's new in SQL Data Compare 16.0
Strengthening security when saving passwords
When you choose to remember credentials while saving a project file, SQL Compare will now save your password to the Windows Credential Store, whereas older versions also saved a copy to the project file. This makes sure that database passwords aren't accidentally shared with other users, and only users that know the password can connect to the database.
Support for connecting to the new SQL Server 2025 database
We have been busy upgrading our tests and fixing issues to make sure we're ready for when you start using SQL Server 2025. You can connect to SQL Server 2025 databases and use them as a Source or Target for comparisons and deployments.
16.0.16.28949 - 21 May 2026
FREQUENT UPDATES RELEASE
16.0.15.28900 - 12 May 2026
FREQUENT UPDATES RELEASE
16.0.14.28844 - 05 May 2026
New feature
- Add an option to include existence checks when generating insert statements
Breaking change
- The Docker image base has changed from Ubuntu Noble to Alpine 3.23. If you use this image as a base for your own Dockerfile, you will need to update it to use Alpine-compatible commands (e.g.
apk addinstead ofapt-get install).
Improvement
- The Docker image base has been updated from Ubuntu Noble to Alpine 3.23, reducing image size and resolving security vulnerabilities in the base OS.
Bug Fix
- SQL Data Compare will refresh the comparison when options are changed, to ensure the change is reflected in the deployment script.
16.0.13.28757 - 21 April 2026
FREQUENT UPDATES RELEASE
16.0.12.28712 - 14 April 2026
16.0.11.28694 - 08 April 2026
FREQUENT UPDATES RELEASE
Engine API
- Modernized engine progress tracking
16.0.10.28672 - 31 March 2026
FREQUENT UPDATES RELEASE
16.0.9.28654 - 24 March 2026
FREQUENT UPDATES RELEASE
16.0.8.28634 - 17 March 2026
FREQUENT UPDATES RELEASE
16.0.7.28607 - 04 March 2026
FREQUENT UPDATES RELEASE
16.0.6.28582 - 24 February 2026
FREQUENT UPDATES RELEASE
16.0.5.28494 - 28 January 2026
Feature
- Add support for JSON Data Type in SQL Server 2025
16.0.4.28477 - 20 January 2026
FREQUENT UPDATES RELEASE
Bug fix
- Fixed offline licensing workflow for SQL Compare docker container
16.0.3.28451 - 14 January 2026
FREQUENT UPDATES RELEASE
16.0.2.28399 - 06 January 2026
FREQUENT UPDATES RELEASE
16.0.1.28365 - 19 December 2025
FREQUENT UPDATES RELEASE
New feature
- Use Distroless base image for Data Compare docker image to reduce image size and improve security.
Bug fix
- ZD-345268: Fixed an issue preventing viewing a deployment script for an object
Improvement
- Add the name of the file where a parsing error occurs into the error message
16.0.0.28327 - 11 December 2025
Breaking change
- Remove support for storing passwords in the project file and instead store these passwords in the Windows Credential Manager.
15.4.29.28207 - 04 December 2025
15.4.28.28077 - 14 November 2025
FREQUENT UPDATES RELEASE
Features
- Support for SQL Server 2025. New SQL Server 2025 features may not function correctly.
15.4.27.28006 - 04 November 2025
FREQUENT UPDATES RELEASE
Features
- Added support for SSMS 21 as an external SQL Editor
15.4.26.27858 - 02 October 2025
FREQUENT UPDATES RELEASE
Fixes
- ZD-335741: Fixed an issue with “Use checksum comparison” option producing an “Object reference not set to an instance of an object” error
- Fixes incorrect exit code being returned when a licensing error occurs
15.4.25.29287 - 18 September 2025
FREQUENT UPDATES RELEASE
15.4.24.29094 - 02 September 2025
FREQUENT UPDATES RELEASE
Fixes
- ZD-338367: Fixed issue where the deploy now button is greyed out if the deployment script only deletes rows
15.4.23.28990 - 20 August 2025
15.4.22.28888 - 11 August 2025
FREQUENT UPDATES RELEASE
15.4.21.28685 - 15 July 2025
FREQUENT UPDATES RELEASE
15.4.20.28553 - 17 June 2025
15.4.19.28507 - 12 June 2025
FREQUENT UPDATES RELEASE
15.4.18.28452 - 03 June 2025
FREQUENT UPDATES RELEASE
Fixes
- ZD-332834 and ZD-328669: Fixed handling of DATETIMEOFFSET when the timezone triggers rolling over months
15.4.17.28422 - 29 May 2025
15.4.16.28371 - May 12th, 2025
FREQUENT UPDATES RELEASE
15.4.15.28277 - Apr 16th, 2025
FREQUENT UPDATES RELEASE
Fixes
- ZD327775: Added improved error handling when comparing billions of rows
15.4.14.28133 - Mar 25th, 2025
FREQUENT UPDATES RELEASE
15.4.13.28096 - Mar 13th, 2025
FREQUENT UPDATES RELEASE
15.4.12.28089 - Mar 6th, 2025
FREQUENT UPDATES RELEASE
15.4.11.28054 - Feb 24th, 2025
FREQUENT UPDATES RELEASE
15.4.10.27977 - Feb 6th, 2025
FREQUENT UPDATES RELEASE
Fixes
- ZD-325134: Fixed an issue with Data Compare unable to compare with unsupported data type.
15.4.9.27950 - Jan 31st, 2025
FREQUENT UPDATES RELEASE
15.4.8.27875 - Jan 22nd, 2025
FREQUENT UPDATES RELEASE
15.4.7.27827 - Jan 14th, 2025
FREQUENT UPDATES RELEASE
15.4.6.27751 - Dec 19th, 2024
FREQUENT UPDATES RELEASE
Engine API
- SqlCompareExceptions now provide unredacted Message and ToString() values.
15.4.5.27738 - Dec 17th, 2024
FREQUENT UPDATES RELEASE
15.4.4.27680 - Dec 10th, 2024
FREQUENT UPDATES RELEASE
15.4.3.27665 - Dec 3rd, 2024
Fixes
- Removed the Flyway option from the project dialog, as it had very low usage
15.4.2.27580 - Nov 22nd, 2024
Features
- Updates the licensing client
Fixes
- Allows tool to be used across user profiles on the same machine
- Prioritises licenses correctly
15.4.1.27450 - Nov 12th, 2024
Fixes
- Ensures the user has verified their email address as part of the login flow
15.4.0.27425 - Nov 11th, 2024
FREQUENT UPDATES RELEASE
Features
- Updated licensing with improved UI, integration, security, and trials. Read more at https://www.red-gate.com/blog/redgate-licensing-update
- Serial Keys have been retired.
15.3.14.27393 - Nov 5th, 2024
15.3.13.27313 - Oct 24th, 2024
FREQUENT UPDATES RELEASE
15.3.12.27264 - Oct 15th, 2024
FREQUENT UPDATES RELEASE
Engine API
- SQL Data Compare Engine no longer has a dependeny on
Microsoft.Data.SqlClient. You may need to add this package to your project if you are using the SQL Data Compare Engine NuGet package. - Removed methods marked as Obsolete on public API that depended on
Microsoft.Data.SqlClient. - Removed
.SSMSand.SSMS20versions of the SQL Data Compare Engine NuGet package.
Features
- Added support for the SSMS20 editor
15.3.11.27029 - Sep 17th, 2024
FREQUENT UPDATES RELEASE
Engine API
- Removed dependency on System.Text.Json. When using the ComparisonSessionSerializer, you will now need to provide an implementation of
IJsonSerializer.
15.3.10.26944 - Sep 12th, 2024
FREQUENT UPDATES RELEASE
Fixes
- Stability improvements for the UI
15.3.9.26398 - Jul 31st, 2024
FREQUENT UPDATES RELEASE
15.3.8.26171 - Jul 16th, 2024
FREQUENT UPDATES RELEASE
Fixes
- Changed the name of sqldatacompare.tar.gz to include the version number
15.3.7.25849 - Jun 4th, 2024
FREQUENT UPDATES RELEASE
15.3.6.25729 - May 8th, 2024
Fixes
- ZD-308402: Data rows selection will now be preserved when swapping compare/synchronization directions.
15.3.5.25572 - Apr 9th, 2024
FREQUENT UPDATES RELEASE
15.3.4.25528 - Mar 26th, 2024
FREQUENT UPDATES RELEASE
Fixes
- ZD-307150: Fixed issue when connecting to Azure SQL instance where an error occurred related to the loading of assembly Microsoft.IdentityModel.Abstractions
15.3.3.25341 - Feb 27th, 2024
FREQUENT UPDATES RELEASE
15.3.2.25249 - Feb 15th, 2024
FREQUENT UPDATES RELEASE
Engine API
- Upgraded to Microsoft.Data.SqlClient 5.1.5
15.3.1.25177 - Feb 6th, 2024
FREQUENT UPDATES RELEASE
Fixes
- ZD-296925: Fixed an issue when comparing graph tables.
15.3.0.25068 - Jan 12th, 2024
Engine API
- Upgraded to Microsoft.Data.SqlClient 5.1.4
Features
- Added read-only support for Flyway projects, allowing you perform comparisons with Flyway on the left.
Fixes
- ZD-304352 Prevent table mappings from incorrectly reverting to default state when editing a project.
15.2.7.24880 - Dec 27th, 2023
FREQUENT UPDATES RELEASE
15.2.6.24771 - Dec 12th, 2023
FREQUENT UPDATES RELEASE
15.2.5.24669 - Dec 5th, 2023
FREQUENT UPDATES RELEASE
Features
- ZD-299431: Slightly reduced memory usage of the UI and engine.
- ZD-299431: Deployment script syntax highlighting is now disabled for scripts exceeding 300k lines for performance reasons.
Fixes
- ZD-299431: Fixed a memory leak in the SQL Data Compare UI, noticeable when refreshing large comparisons.
- ZD-299431: Fixed a crash on the pre-deploy Summary tab when toggling the grouping for large deploys.
15.2.4.24551 - Nov 28th, 2023
FREQUENT UPDATES RELEASE
15.2.3.24503 - Nov 21st, 2023
FREQUENT UPDATES RELEASE
15.2.2.24260 - Nov 7th, 2023
FREQUENT UPDATES RELEASE
15.2.1.24235 - Oct 31st, 2023
Fixes
- ZD-292086: Fixed an issue where Include checkboxes would re-tick themselves if multiple schemas had a table with the same name.
15.2.0.24040 - Oct 6th, 2023
FREQUENT UPDATES RELEASE
Features
- ZD-297510: Made the table mapping screens more responsive by significantly reducing the number of times they reprocess saved data.
- Note that the project Save button no longer grays out when there are no unsaved changes.
15.1.2.24012 - Sep 28th, 2023
FREQUENT UPDATES RELEASE
Fixes
- Update to licencing link in CLI output
15.1.1.23971 - Sep 20th, 2023
FREQUENT UPDATES RELEASE
15.1.0.23826 - 06 September 2023
Engine API
- Added link to licensing restrictions documentation in CLI output header
15.0.13.23797 - 29 August 2023
Fixes
- ZD-294648: Fixes misleading record Include checkbox behavior in Data Compare following a refresh/deployment. Checkboxes now reset to a ticked/un-ticked state, based on the object grid checkbox.
15.0.12.23728 - Aug 9th, 2023
FREQUENT UPDATES RELEASE
15.0.11.23723 - 08 August 2023
Fixes
- ZD-285053: Fixes an issue in the command line where options such as “TrustServerCertificate” in the server switches were not being used
15.0.10.23691 - Aug 1st, 2023
FREQUENT UPDATES RELEASE
15.0.9.23488 - May 30th, 2023
Fixes
- ZD-292465: Added SSMS19 to list of SQL editor options
15.0.8.23473 - May 23rd, 2023
FREQUENT UPDATES RELEASE
Engine API
- Upgraded to Microsoft.Data.SqlClient 5.1.1
15.0.7.23280 - Mar 14th, 2023
FREQUENT UPDATES RELEASE
Fixes
- “Encrypt” and “Trust server certificate” server connection checkbox values are now loaded with server connection details from server dropdown
15.0.6.23274 - Mar 7th, 2023
FREQUENT UPDATES RELEASE
Fixes
- ZD-284324: Fixes a bug where an “Identical items are not deployed.”-error was incorrectly being raised when deploying to scripts folders
15.0.5.23181 - Feb 21st, 2023
FREQUENT UPDATES RELEASE
Fixes
- ZD-285412: Fixed issue with table mappings not appearing when connecting through Azure MFA to a managed instance
15.0.4.23133 - Feb 14th, 2023
FREQUENT UPDATES RELEASE
Fixes
- Added warning to command line clarifying which differences will be deployed
15.0.3.23021 - Jan 24th, 2023
FREQUENT UPDATES RELEASE
15.0.2.22953 - Jan 17th, 2023
Features
- ZD-282763 “Encrypt” and “Trust Server Certificate” can now be specified on database connections with checkboxes, rather than the workround of manually appending connection string parameters to the server name
Fixes
- Fixed minor bugs relating to the handling of long file paths
15.0.1.22876 - Jan 11th, 2023
FREQUENT UPDATES RELEASE
Features
- ZD-283578: Added “Dynamically override default save location when saving to a new location in the deployment script save dialog” option to application settings.
15.0.0.22793 - Dec 20th, 2022
FREQUENT UPDATES RELEASE
Features
- SQL Server 2022 support
- UI displays a warning that support for SQL Server 2008 and SQL Server 2008R2 will be removed in a future version
- UI displays a warning when an unsupported scripts folder is selected
14.10.9.22680 - Dec 8th, 2022
FREQUENT UPDATES RELEASE
14.10.8.22508 - Nov 24th, 2022
FREQUENT UPDATES RELEASE
Features
- Added support for long file paths in windows when enabled in the windows registry (We cannot guarantee how it will work with windows and other applications as it does not seem well supported)
Fixes
-ZD-280317: Fixed missing dll reference that appears when attempting Azure authentication.
14.10.7.22333 - Nov 15th, 2022
FREQUENT UPDATES RELEASE
14.10.6.22196 - Nov 3rd, 2022
FREQUENT UPDATES RELEASE
Fixes
- SQL Compare will no longer install the Microsoft Active Directory Authentication Library (ADAL) as a pre-requisite as it is superseded by MSAL
14.10.5.22107 - Oct 18th, 2022
FREQUENT UPDATES RELEASE
14.10.4.22065 - Oct 11th, 2022
FREQUENT UPDATES RELEASE
Engine API
- Upgraded to Microsoft.Data.SqlClient 5.0.1
Fixes
- ZD-277198: Fixed missing dll reference that appears when attempting Azure authentication
14.10.3.21932 - Oct 4th, 2022
FREQUENT UPDATES RELEASE
14.10.2.21877 - Sep 28th, 2022
FREQUENT UPDATES RELEASE
Fixes
ZD-278082: Fixed shift+up/down arrow keys not selecting rows as expected in row differences pane
14.10.1.21845 - Sep 21st, 2022
FREQUENT UPDATES RELEASE
14.10.0.21773 - Sep 13th, 2022
FREQUENT UPDATES RELEASE
Features
- Beta support for SQL Server 2022 Preview. New SQL 2022 features may not function properly.
Fixes
ZD-275896: Fixed an issue with comparing empty tables with “Use checksum comparison” enabled
14.9.3.21711 - Sep 6th, 2022
FREQUENT UPDATES RELEASE
14.9.2.21665 - Aug 30th, 2022
FREQUENT UPDATES RELEASE
14.9.1.21642 - Aug 16th, 2022
FREQUENT UPDATES RELEASE
14.9.0.21563 - Aug 10th, 2022
FREQUENT UPDATES RELEASE
Features
- ER-71: Change to the process by which static data is written to scripts folders in order to improve ordering consistency.
14.8.5.21499 - Jul 26th, 2022
FREQUENT UPDATES RELEASE
14.8.4.21440 - Jul 19th, 2022
FREQUENT UPDATES RELEASE
Fixes
- ZD-274628: Fixed deploying changes to an edge table that has an identity column as its primary key
14.8.3.21395 - Jul 5th, 2022
FREQUENT UPDATES RELEASE
Fixes
- Fixes an issue with verifying server certificates when an explicit port number is set.
14.8.2.21320 - Jun 28th, 2022
FREQUENT UPDATES RELEASE
14.8.1.21249 - Jun 22nd, 2022
FREQUENT UPDATES RELEASE
14.8.0.21190 - Jun 14th, 2022
FREQUENT UPDATES RELEASE
Strapline
30 - SQL Server connections encrypted by default 20 - Application ID no longer required for Azure Universal Auth
Engine API
- Upgraded to Microsoft.Data.SqlClient 4.1.0
Features
- SQL Data Compare now encrypts connections to SQL Server by default Previously, connections would have been encrypted according to the server’s Force Encryption setting
- Setting an Application ID is no longer needed to connect using Azure Active Directory Universal with MFA authentication
- Linux command line timebomb doubled to 180 days
14.7.8.21163 - Jun 8th, 2022
14.7.7.21053 - May 24th, 2022
FREQUENT UPDATES RELEASE
Fixes
- ZD-269383 Fixed an issue with sorting order of data in a scripts folder, with UTF8 collations
14.7.6.21017 - May 17th, 2022
FREQUENT UPDATES RELEASE
Fixes
- ZD-269383 Fixed an issue with comparison and deployment of data containing accented characters in char/varchar/text columns, with Latin1_General_100_CS_AS_SC_UTF8 and similar 100 collations
14.7.5.20971 - Apr 26th, 2022
FREQUENT UPDATES RELEASE
14.7.4.20967 - Apr 25th, 2022
FREQUENT UPDATES RELEASE
14.7.3.20962 - Apr 21st, 2022
FREQUENT UPDATES RELEASE
14.7.2.20940 - Apr 7th, 2022
FREQUENT UPDATES RELEASE
Fixes
- ZD-268685 When FIPS is enabled, encrypted objects are now correctly decrypted, when the option to do so is set
14.7.1.20862 - Mar 22nd, 2022
FREQUENT UPDATES RELEASE
14.7.0.20823 - Mar 16th, 2022
FREQUENT UPDATES RELEASE
14.6.20.20708 - Mar 1st, 2022
FREQUENT UPDATES RELEASE
14.6.19.20650 - Feb 22nd, 2022
FREQUENT UPDATES RELEASE
14.6.18.20606 - Feb 15th, 2022
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.17.20533 - February 3rd 2022
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.16.20465 - January 25th 2022
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.15.20403 - January 12th 2022
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.14.20342 - December 22nd 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- ZD-260221 More use of WITH (NOLOCK) on DMV queries
14.6.13.20238 - December 8th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.12.20158 - November 29th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- To support automation environments, the SQL Compare command line now has an /allUsers flag that can be using when activating to allow it to be used by all users, including service accounts
14.6.11.20142 - November 22nd 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.10.20102 - November 10th 2021
Strapline
10 - Bug fixes
14.6.9.20059 - November 1st 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- ZD-261137: Support for SQL Server 2019 differential backups fixed
14.6.8.20031 - October 26th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.7.20011 - October 18th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- ZD259357: Fixed issue in the project settings dialog where the username for a database using Active Directory universal with MFA auth could get copied over the other database’s username
14.6.6.19949 - October 5th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
ZD-259150: Fixed issue with modal windows not appearing on expected monitor
14.6.5.19910 - September 27th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.4.19846 - September 20th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.3.19802 - September 16th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Engine API
- Upgraded to Microsoft.Data.SqlClient v3
Fixes
- Fixed Active Directory universal with MFA authentication
14.6.2.19746 - September 13th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.1.19650 - September 6th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.6.0.19635 - August 19th 2021
FREQUENT UPDATES RELEASE
Strapline
20 - Comparing decimal fields with full precision
Features
- Previously, when comparing two decimal fields with a different number of decimal places, in which a number in the source was different to the number in the target, but equal after rounding, we would not list that as a difference. This behaviour has now been changed so that these will be shown in the list of differences.
14.5.22.19589 - August 16th 2021
Strapline
10 - Bug fixes
14.5.21.19562 - August 9th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.20.19533 - August 2nd 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- sql_variant fields with a NULL value now show as ‘<NULL>’ instead of ‘Null’, to be consistent with other data types
14.5.19.19515 - July 26th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- Improved performance of reading from backup files
14.5.18.19506 - July 22nd 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.17.19461 - July 19th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- ZD-252839 - Respect the users decision of turning off some default DCE options
14.5.16.19388 - July 12th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.15.19373 - July 5th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- Changed default deployment script encoding to UTF-8
- Changed default CSV report encoding to UTF-8
14.5.14.19355 - June 30th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.13.19322 - June 23rd 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.12.19294 - June 15th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.11.19213 - June 7th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.10.19206 - June 2nd 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.9.19133 - May 24th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Fixed help menu link
14.5.8.19095 - May 19th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.7.19065 - May 11th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.6.18966 - May 5th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.5.5.18909 - April 27th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- ZD-248719: Parser messages are now propagated to command-line output.
14.5.4.18843 - April 19th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Engine API
- Updated to Newtonsoft.Json 13
14.5.3.18766 - April 12th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Internal
- Exception reports now go to Application Insights instead of Raygun
14.5.2.18630 - March 23rd 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- ZD-247451: Respect command line parameters MaxTransactionSizeDB and TransactionIsolationLevel
14.5.1.18536 - March 15th 2021
Strapline
10 - Bug fixes
14.5.0.18430 - March 4th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.23.18321 - February 22nd 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-10963: The /makescripts option on the command line no longer writes out migration blocks metadata for non-migration blocks databases
14.4.22.18256 - February 15th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.21.18202 - February 8th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.20.18129 - February 1st 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.19.18070 - January 25th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.18.17935 - January 18th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.17.17847 - January 11th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.16.17770 - January 5th 2021
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.15.17626 - December 14th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.14.17548 - December 7th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Fixed a NullReferenceException when deploying to a scripts folder with a missing target of a foreign key
14.4.13.17493 - November 30th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.12.17429 - November 25th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- The DoNotOutputCommentHeader option is now respected in the SQL Data Compare command line
- ZD194840: SQL Data Compare UI now applies selections correctly when Include Identical Values In Results is ticked
14.4.11.17350 - November 16th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.10.17174 - November 3rd 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-3100: The /Include:Additional command line switch will no longer include rows that are present in the source
14.4.9.17070 - October 26th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.8.17007 - October 19th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.7.16962 - October 12th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.6.16906 - October 5th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.5.16856 - September 28th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.4.16824 - September 23rd 2020
Strapline
10 - Bug fixes
14.4.3.16779 - September 16th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.2.16694 - September 7th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.1.16663 - September 2nd 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.4.0.16632 - August 24th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Improved consistency between command line and UI behaviours
14.3.4.16598 - August 19th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.3.3.16559 - August 11th 2020
Strapline
10 - Bug fixes
14.3.2.16501 - July 30th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.3.1.16487 - July 27th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Checksum comparison now works against read-only databases
14.3.0.16423 - July 20th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Engine API
- Engine now uses Microsoft.Data.SqlClient instead of System.Data.SqlClient
- Engine now depends on SmartAssembly.Attributes package
Features
- SQL Data Compare will now reject self-signed certificates when connecting over the internet to SQL Servers with force encryption enabled
- SQL Data Compare command line on Linux now supports Azure Active Directory Password authentication
14.2.19.16383 - July 13th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.18.16317 - July 6th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.17.16188 - June 23rd 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.16.16006 - June 4th 2020
Strapline
10 - Bug fixes
Fixes
- SC-10848: Fixed issue where saved passwords could be forgotten
14.2.15.15984 - June 1st 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-1451: When reading from a backup file, not null columns added with a default value are now read correctly
- When reading from a backup file, sql_variant columns containing time, datetime2, or datetimeoffset values are now read correctly
14.2.14.15839 - May 18th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.13.15781 - May 11th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.12.15739 - May 4th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.11.15654 - April 29th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2992: Fixed partial deployments to scripts folders
14.2.10.15571 - April 22nd 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.9.15508 - April 9th 2020
Strapline
10 - Bug fixes
14.2.8.15465 - April 6th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
ZD158416: SQL Data Compare can now unmap/remap tables with names that differ by case when using case insensitive mapping options
14.2.7.15427 - March 30th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.6.15412 - March 23rd 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.5.15352 - March 16th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.4.15334 - March 5th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.3.15242 - March 2nd 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.2.15139 - February 24th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.2.1.15041 - February 11th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-3027: Columns with incompatible data types that get automapped no longer prevent comparisons
- SC-10773: Scripts folders containing Microsoft Database projects are now correctly recognized
- SDC-3029: Some custom comparison keys no longer cause tables to be excluded from the comparison
14.2.0.14846 - January 29th 2020
FREQUENT UPDATES RELEASE
Strapline
20 - Azure Active Directory Interactive Authentication
Features
- SQL Data Compare now supports Azure Active Directory Interactive Authentication
14.1.10.14805 - January 27th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.1.9.14719 - January 21st 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.1.8.14471 - January 7th 2020
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-3019: Where clause editor is now disabled for incompatible data sources
- The open projects button no longer exhibits erroneous dropdown behavior
14.1.7.14336 - December 18th 2019
Strapline
10 - Bug fixes
14.1.6.14245 - December 16th 2019
FREQUENT UPDATES RELEASE
Strapline
20 - Backup before deploy on Azure managed instances
Features
- Azure Managed Instances can now take backups before deployment to a supplied URL.
14.1.5.14025 - December 2nd 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- SQL Data Compare will now install the Microsoft Active Directory Authentication Library if it is required
14.1.4.13974 - November 25th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.1.3.13888 - November 18th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-3004: The command line no longer attempts to deploy tables with no comparison key
14.1.2.13797 - November 11th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-10654: Launching SSMS 18 from SQL Data Compare now behaves correctly when using SQL Authentication
14.1.1.13725 - November 5th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- You can no longer add a backup statement to a script that is immediately run on an Azure server, which would always cause the script to fail.
- ‘master’ no longer appears on the database list for Azure SQL Database and we no longer allow you to register it, as it is not really a full database and may have unexpected behaviour.
- SDC-2997: We no longer deselect the whole table when you have a column deselect in your project which doesn’t match any registered columns, because this was causing us to deselect tables where the column was hidden by an option e.g. ignore timestamp columns.
- SQL Data Compare no longer attempts to connect to an Azure SQL Database to check SQL Backup install status or do folder browsing, neither of which work on Azure SQL Database.
14.1.0.13605 - October 28th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Improved error messages around Azure Active Directory authentication.
- Improved labelling of authentication types to make it clearer which ones are only applicable to on-prem or Azure SQL Database connections.
14.0.7.13517 - October 21st 2019
Strapline
10 - Bug fixes
14.0.6.13387 - October 14th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- Enabled sharing of recently used servers with other Redgate products
14.0.5.13297 - October 7th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-10056: Server combobox in the live database connection form now correctly updates when clicking the swap sides button
14.0.4.13251 - October 2nd 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
14.0.3.13106 - September 23rd 2019
FREQUENT UPDATES RELEASE
Strapline
40 - Linux command line support 10 - Bug fixes
Features
- SQL Data Compare command line is now available as a linux container on Docker Hub
Fixes
- Command line on Linux now logs to the
/logsdirectory
14.0.2.13006 - September 16th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2986: The deployment progress dialog will now only display the last element in a batch
14.0.1.12901 - September 9th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- Server retrieval in connection dialog now retrieves local server instances more comprehensively
14.0.0.12866 - September 4th 2019
Strapline
60 - SQL Server 2019 support
13.8.0.12703 - August 27th 2019
FREQUENT UPDATES RELEASE
Strapline
20 - Faster scripts parsing
Features
- Faster script parser - scripts folders should load data much faster from all tables.
- New command line error code - 60 - for the state where there are no comparable tables/views. This would previously have returned error code 63, which now only covers identical databases.
13.7.22.12352 - August 12th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.21.12250 - July 31st 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2976: Stop mappings list entirely refreshing itself and resetting scroll position to the top when e.g. column selection edits are made
- SOC-9937: Improved handling of static data for unusual table names
13.7.20.12175 - July 29th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Fixed a crash when SQL contains hundreds of nested parentheses.
13.7.19.12066 - July 22nd 2019
Strapline
10 - Bug fixes
Features
- Tables that had no available comparison key, and hence could not be compared, are now displayed in command line output with the string ‘No PK or UQ’ in the ‘Records’ column and ‘x’ in the DB1 and DB2 columns, rather than entirely ignored. Similarly, tables with no data in will be displayed with the string ‘No data’ in the ‘Records’ column and ‘x’ in the DB1 and DB2 columns. These will only appear if /Include:Identical is specified, as they can’t form part of a deployment.
13.7.18.11916 - July 15th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2763: You can now bring up the difference viewer more easily when you edit a project with only one table/view and re-compare
13.7.17.11774 - July 8th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.16.11325 - June 13th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2955: New projects will now get a new set of table / schema mappings, rather than reusing the previous project’s mappings if the data sources matched.
13.7.15.11228 - June 6th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.14.11151 - June 3rd 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.13.10771 - May 13th 2019
Strapline
10 - Bug fixes
13.7.12.10555 - May 7th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.11.10438 - April 29th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.10.10373 - April 23rd 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.9.10201 - April 10th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.8.10109 - April 1st 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2938: Data compare command line no longer throws away options in the project file when using the project switch
13.7.7.10021 - March 26th 2019
Strapline
10 - Bug fixes
Engine API
- Removed remaining vestigial dependency on SMO package.
- SQL Data Compare Engine now dual targets both net461 and netstandard2.0. Please note that netstandard2.0 versions of the Compare and Data Compare engines are not really ready for use in anger.
13.7.6.9920 - March 18th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Engine API
- RedGate.SQLCompare.ASTParser NuGet package has been updated to include both net461 and netstandard2.0 content.
- Removed dependency on Microsoft.SqlServer.ManagementObjects NuGet package.
Fixes
- SQLite dependency upgraded to version 1.0.110
13.7.5.9811 - March 11th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Engine API
- Engine NuGet packages now have the packaged assemblies delivered in the
lib\net461folder, rather than thelibfolder directly.
13.7.4.9637 - February 28th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.3.9483 - February 20th 2019
Strapline
10 - Bug fixes
Features
- SDC-1639: Transaction isolation level can now be specified
13.7.2.9407 - February 18th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Engine API
- The ongoing migration of our project files to the VS 2017 format may introduce subtle changes to the various Compare and Data Compare NuGet packages.
- The
RedGate.SQLCompare.ASTParserandRedGate.SQLCompare.EngineNuGet packages now include some previously missing NuGet package dependencies. These may potentially result in downstream dependency conflicts.
Fixes
- SDC-2927: Concatenated strings in static data can now be parsed
- SDC-2930: Fixed a code path where certain deployment options could be ignored
13.7.1.9280 - February 11th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.7.0.9250 - February 7th 2019
Strapline
10 - Bug fixes
Fixes
- SDC-2906: Worked around a Windows Installer error that caused Microsoft.SqlServer.Management.SqlParser.dll to be removed when upgrading SQL Data Compare.
- SDC-2925: Rows on node tables are now added before rows on edge tables, and vice versa when deleting rows
13.6.14.9174 - February 4th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- Additional logging of .NET assembly loading to help investigate SDC-2906.
13.6.13.9079 - January 31st 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.6.12.9031 - January 28th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.6.11.8947 - January 23rd 2019
Strapline
10 - Bug fixes
Fixes
- Fixed an issue with SOC integration
13.6.10.8927 - January 22nd 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.6.9.8731 - January 14th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.6.8.8602 - January 8th 2019
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Minor script ordering change - constraint and key nocheck and drop statements will now group slightly differently (check constraints are now in their own section rather than mixed in with primary, unique and foreign keys)
- SDC-2914 Fixes comparison between TINYINT and NUMERIC(x,y) columns
13.6.7.8464 - December 18th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.6.6.8387 - December 11th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.6.5.8288 - November 26th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.6.4.8233 - November 21st 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.6.3.8160 - November 12th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2889: Stop Data Compare from creating an additional folder in the scripts data when generating a deployment script
Internal
- SOC-9648: Fixed issue where DataFileSet is not updated when using Synchronise
- SDC-2889: As part of 2889 above I renamed DisposeOfSyncInfo to DisposeOfExecutionBlock which is called twice from SQLSourceControl
13.6.2.7987 - October 23rd 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2747: When resizing the comparison key window in a mapping dialog, the scrollbar no longer disappears
- SDC-2894: The command line now exits with the correct exit code when the license is invalid
Internal
- The SQL Data Compare UI build now runs the Compare Engine through SmartAssembly
13.6.1.7928 - October 17th 2018
Strapline
10 - Bug fixes
13.6.0.7862 - October 15th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.5.2.7785 - October 9th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.5.1.7638 - September 24th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2884 - MissingIn2AsInclude command line option now includes key columns again in output script
13.5.0.7565 - September 17th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.4.8.7337 - September 3rd 2018
Strapline
10 - Bug fixes
Engine API
- The SQL Data Compare Engine package now directly references Microsoft.SqlServer.SqlManagementObjects insead of relying on a transitive reference through SQL Compare Engine.
Fixes
- SQL Data Compare now correctly outputs server name as part of the source and target databas names in CSV report exported from the command line
13.4.7.7223 - August 20th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.4.6.7079 - August 13th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2861: Reduce re-registrations in the edit project dialog
13.4.5.6953 - July 30th 2018
Strapline
10 - Bug fixes
13.4.4.6883 - July 24th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- SDC-1262 Option to include a USE <databaseName> statement added, consistent with SQL Compare
13.4.3.6777 - July 17th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.4.2.6669 - July 2nd 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2833: Dropping an index linked via a foreign key to a table that is not selected for deployment will now ensure the foreign key dependency is respected
13.4.1.6601 - June 25th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.4.0.6563 - June 20th 2018
Strapline
30 - WHERE clause improvements 10 - Bug fixes
Features
- SDC-2862: If “WHERE” is included in a where clause, it no longer causes a broken update script
13.3.8.6436 - June 11th 2018
Strapline
10 - Bug fixes
Fixes
- SQL Data Compare more consistently compares data from a scripts folder when using a VARCHAR comparison key.
13.3.7.6422 - June 11th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.3.6.6375 - June 4th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- SDC-2857: Add option to include generated always columns in the comparison
Fixes
- SDC-2844: Update collations to use Microsoft library to improve consistency
- Performance improvements when populating indexes from a database
13.3.5.6244 - May 23rd 2018
Strapline
10 - Bug fixes
Fixes
- Telemetry has been updated in accordance with the privacy policy available at https://www.red-gate.com/website/legal
13.3.4.6198 - May 17th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Engine API
Redgate.*.Obfuscatedpackages no longer built
Fixes
- SDC-2843: SQL Data Compare command line won’t throw an error when an unmapped column that doesn’t exist in the source is excluded on the command line
13.3.3.6037 - May 1st 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
SDC-2837: SQL Data Compare now handles comparisons of tables with a non-mapped computed field
13.3.2.5875 - April 17th 2018
Strapline
10 - Bug fixes
Fixes
- SDC-2826: The ‘Drop primary keys, indexes, and unique constraints’ option no longer drops unique ROWGUIDCOL indexes on tables that include a FILESTREAM field.
- SC-10036: The SQL Data Compare command line will no longer fail when there is whitespace between options in an XML argument file
13.3.1.5775 - April 9th 2018
FREQUENT UPDATES RELEASE
Strapline
30 - Commandline active directory auth 10 - Bug fixes
Features
- SQL Data Compare command line now includes switches /activedirectory1 and /activedirectory2 to specify the use of Azure Active Directory authentication
Fixes
- SDC-2799: The
Reseed identity columnsoption now sets the current seed of the target to the current seed of the source when possible
13.3.0.5760 - April 4th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.2.4.5728 - March 23rd 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Engine API
Differences.Remove()has been renamed toFilter().Differenceobjects passed to this method will have theirSelectedproperty set to false.
13.2.3.5714 - March 21st 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.2.2.5661 - March 12th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.2.1.5640 - March 1st 2018
Strapline
10 - Bug fixes
Fixes
- Bulk uninstaller improvements
13.2.0.5604 - February 20th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.1.11.5591 - February 13th 2018
Strapline
10 - Bug fixes
13.1.10.5564 - January 30th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.1.9.5540 - January 16th 2018
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2798: Fixed some incorrect script comments regarding SQL Graph EGDE tables.
13.1.8.5525 - January 8th 2018
Strapline
10 - Bug fixes
Features
- Integrates the Redgate bulk uninstaller
13.1.7.5470 - December 11th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2788: Fixed a memory leak during deployment.
13.1.6.5463 - December 5th 2017
Strapline
10 - Bug fixes
Fixes
- SC-9683: Fixed display of warning message text, which was invisible for some .NET 4.7 users
- SQL Data Compare Command Line now runs in 64-bit mode by default
13.1.5.5427 - November 27th 2017
Strapline
10 - Bug fixes
13.1.4.5418 - November 20th 2017
Strapline
10 - Bug fixes
13.1.3.5405 - November 14th 2017
Strapline
10 - Bug fixes
Fixes
- SDC-2764: Fixed a Windows Clipboard interaction bug when choosing which server to connect to
13.1.2.5327 - October 30th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.1.1.5299 - October 23rd 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
13.1.0.5287 - October 16th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- SDC-2745: Display pseudo column names for column headers instead of the full column name
Fixes
- SC-8880: Scripts folders can now be in the root of a drive (as long as it is otherwise empty)
- SDC-2753: Fixed a crash at the start of the Deployment Wizard
13.0.6.5248 - October 9th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-9740: Ensured that warning messages correctly show a title next to the icon
13.0.5.5219 - October 2nd 2017
Strapline
10 - Bug fixes
Features
- SQL Data Compare now requires .NET 4.6.1
- Improved the installer UI for SQL Data Compare
13.0.4.5168 - September 25th 2017
Strapline
10 - Bug fixes
13.0.3.5144 - September 19th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-9175: fix an issue where incorrect credentials could be used when registering, after typing server names into the connection dialog.
13.0.2.5109 - September 11th 2017
Strapline
40 - Password saving 30 - Open scripts in SSMS 2017 10 - Bug fixes
Features
- SQL Data Compare now lists SQL Server Management Studio 17 as a default script editor
- SQL Data Compare now remembers passwords in the Windows Credential Store, as well as the project file.
13.0.1.5078 - September 4th 2017
Strapline
10 - Bug fixes
Engine API
- SQL Data Compare Engine now targets .NET 4.0 instead of .NET 3.5
Fixes
- SDC-2639: Fixed a crash when performing checksum comparisons
- SC-9662: The command line now displays your serial number correctly
13.0.0.5057 - August 29th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2555, SDC-2199, SDC-2224: SQL Data Compare now drops foreign keys to allow other indexes to be dropped
12.4.12.5042 - August 24th 2017
Strapline
10 - Bug fixes
12.4.11.5008 - August 21st 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2557: Remove “Create a SQL Compare snapshot” as a backup target option since it doesn’t perform any operations
12.4.10.4968 - August 8th 2017
Strapline
10 - Bug fixes
12.4.9.4945 - July 31st 2017
Strapline
10 - Bug fixes
Features
- SC-9335: SQL Data Compare now supports Azure Active Directory authentication with integrated and password authentication methods. These options are available in the ‘Authentication’ dropdown in the ‘Database’ section of the ‘Edit project’ window. Note that this feature requires .NET 4.6 and adalsql.dll to be installed; see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure#configure-your-client-computers for more details
Fixes
- SDC-2556: Fixed a crash when recomparing data after a deployment
12.4.8.4926 - July 26th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2553: Data Compare no longer crashes when attempting to view the comparison key or column mapping dialogs
12.4.7.4905 - July 13th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-9509: The ‘Export CSV files’ menu item will now be enabled after comparing a project from the ‘My projects’ window using the ‘Compare now’ option
- SC-9514: Switching deployment direction will no longer cause the currently selected table to be deselected
- Fixed an issue where cancelling a comparison at a specific moment could cause SQL Data Compare to hang
12.4.6.4860 - July 4th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
12.4.5.4811 - June 28th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
12.4.4.4771 - June 21st 2017
FREQUENT UPDATES RELEASE Compatibility with SQL Compare 12.4.4.4771
12.4.3.4752 - June 20th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-9494: SQL Compare will no longer truncate extra long warnings in the deployment wizard
- SDC-2502: SQL Data Compare should now correctly preserve newline characters in multiline strings in the deployment script
- SDC-2509: Fixed a bug which could cause the ‘Selected X of Y’ count in the results grid to get out of sync after refreshing the comparison.
12.4.2.4681 - June 7th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2548: SQL Data Compare can now hide columns with no different values, even if inserted and deleted values exist
- SC-9437: Fixed a bug which could cause some rows in the My Projects dialog to not render correctly when there were some invalid project files in the displayed folder
12.4.1.4639 - May 30th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- The authentication type for databases (Windows/SQL Server) is now specified as a dropdown. This allows more authentication types to be added in the future.
Fixes
- SDC-2547: Fixed an error displaying columns in the correct order when switching between tabs in the differences grid.
- SC-9404: Fixed a bug which prevented the saved sort order in the My Projects dialog from being applied correctly
- SC-9456: Fixed some high-DPI display issues in the deployment wizard ‘Deployment method’ settings that occurred when the windows UI scale was set to 250% or greater
- SDC-2507: When selecting columns for comparison, all selection will now be saved rather than only those that are visible using the “Find” function.
- SC-9439: The “Edit selected file” button on the “Error parsing scripts” dialog will now correctly launch the selected editor
- SC-9474: Fixed some high-DPI display issues in the deployment wizard title bar
12.4.0.4551 - May 16th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
12.3.3.4490 - May 8th 2017
Strapline
10 - Bug fixes
Features
- The “My Projects” window can now be opened from the toolbar
- The ‘Use checksum comparison’ and ‘Treat empty string as NULL’ options can now be used together. Comparing a NULL value and empty string will cause the table checksums to be different, but Data Compare should then treat these values as equal when comparing the tables.
Fixes
- SC-9399: When using the SQL Source Control data source, progress updates will now be displayed while the requested revision of the scripts folder is being checked out.
12.3.2.4426 - April 26th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2459: Data Compare no longer matches on all columns when custom comparison keys are used, and no keys are repeated.
- SDC-2505: Fixed a bug that could prevent Data Compare from scripting out some INSERT/DELETE statements when not all rows were selected and the deployment direction was reversed.
12.3.1.4383 - April 12th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Fixed a silent crash on start up that could occur when upgrading from SQL Data Compare 12.2.3 or 12.2.4
12.3.0.4373 - April 10th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes 60 - SQL Server vNext
Features
- SQL Data Compare can now register SQL Server vNext backups and scripts folders
Fixes
- SDC-2493: Regular expressions are now supported when using the excludecolumns and includecolumns switches in the command line.
- SDC-2485: DateTime data is now formatted consistently in the differences grid.
- SC-9339: The size of the My Projects dialog is now saved between sessions
12.2.4.4299 - March 30th 2017
FREQUENT UPDATES RELEASE
Strapline
50 - Git revision support 10 - Bug fixes
Features
- SC-9066: It is now possible to compare to a historical git revision (Requires SQL Source Control 5.5.4 or later)
Fixes
- SDC-2383: Individual cells in the Data Compare differences grid are now highlighted only when they contain a difference.
- SC-9374, SC-9376: Choosing ‘HEAD’ as the source control revision no longer causes a ‘Value cannot be null’ error in the UI or command line
12.2.3.4239 - March 27th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
12.2.2.4140 - March 13th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Features
- SC-9338: The My Projects dialog will now remember the previous sort ordering
Fixes
- SDC-2448: Improved warning messages around referential integrity.
- SC-9204: Filenames are no longer truncated in the deployment wizard when updating a scripts folder
- SC-8944: Improved the title bars of various dialogs in high DPI mode
12.2.1.4077 - March 6th 2017
Strapline
10 - Bug fixes
Features
- When trialling SQL Compare you now be asked to create a Redgate ID. Please see https://www.red-gate.com/user-licensing for details.
Fixes
- SC-9177: Preserve changes to column widths in the My Projects dialog
- SDC-2424: CSV export settings are now applied to individual rows, not the whole table
12.2.0.4045 - February 22nd 2017
FREQUENT UPDATES RELEASE
Strapline
40 - Temporal tables 20 - Sorted out mapping unknown tables 10 - Bug fixes
Features
- Data Compare can now deploy the current state of data in temporal tables on SQL Server 2016.
Fixes
- SDC-2451: Temporary files are no longer left on disk at application exit
- SDC-2454, SDC-2382, SDC-2286, SDC-2420: Fixed a crash when selecting multiple tables at once for deployment
- SDC-2221: When loading old projects, new tables will be mapped unless “clear all” had been performed
- SDC-2243: Allow the mapping of tables sharing a name in different schemas
- SDC-2423: Fix an issue causing inconsistencies when hiding identical columns in the changes grid.
- SC-9265: Fix an issue that the Deploy button could be incorrectly enabled or disabled
12.1.6.3982 - February 13th 2017
FREQUENT UPDATES RELEASE
Strapline
40 - Option to exclude unknown tables
Features
- Added an option to include or exclude new tables by default
12.1.5.3927 - February 6th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-9197: Support registering databases with users that have the permission ALTER ANY EXTERNAL DATA SOURCE
- SDC-2242: Do not overwrite non .csv files when exporting CSV reports; add an option to overwrite existing files in the directory being exported to
12.1.4.3873 - January 17th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-9153: SQL Data Compare will no longer display an error when loading a project using SQL authentication where the ‘Save Password’ box has not been checked.
- SC-9190: Fixed some checkboxes which were invisible in some cases
12.1.3.3849 - January 16th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- Support sorting the results grid in ascending as well as descending order
- SDC-2241: Improved behaviour of checkboxes on high DPI screens
- SOC-8281: Fixed a casting error when deploying data to Azure
12.1.2.3823 - January 9th 2017
FREQUENT UPDATES RELEASE
Strapline
60 - SSMS v17.0 RC1 plugin 50 - SQL Server on Linux
Features
- SQL Server vNext on Linux is now supported.
- SQL Data Compare SSMS extension now supports latest version (v17.0 RC1) of SQL Server Management Studio
Fixes
- SDC-2239: Fixed a crash when sorting the results by object type
- SC-9160: SQL Data Compare now no longer allows showing multiple create database dialogs
- Fixed a bug where swapping databases in the Edit Project dialog could cause SQL Source Control revision numbers to be associated with the wrong database
12.1.1.3793 - January 4th 2017
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2232: Improved SQL Data Compare performance when selecting or deselecting large numbers of tables in the mappings UI
- SDC-2237: Deployment scripts are now correctly split into multiple transactions based on your “max transaction / batch size” setting
12.1.0.3760 - December 19th 2016
Strapline
70 - Hide identical columns 10 - Bug fixes
Features
- The data difference viewer can now be made to hide columns that are identical in the source and target.
Fixes
- SC-9146: SQL Data Compare now correctly requires professional edition to use source control data sources.
- SDC-2233: SQL Data Compare will no longer hide the top-level checkbox in the table mappings UI when sorting by that column
- SC-9156: The new My Projects dialog will now correctly load projects which specify a SQL Source Control data source
12.0.40.3714 - December 6th 2016
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SC-9111: SQL Data Compare no longer attempts to fetch the SQL Source Control revision number for a database if it is not in the known list of databases for that server. This fixes a bug where typing in the database name would cause repeated failed login attempts.
- SDC-2231, SDC-2228: fix a bug that SQL Data Compare could reselect tables into selected items when custom comparison keys were used.
- SC-8950: SQL Data Compare now accepts /scriptsfolderxml1 and /scriptsfolderxml2 switches (to give different source control information for each database)
- SQL Data Compare has a new ‘my projects’ dialog accessible from the File menu. The new dialog can also be made to show by default at startup.
12.0.39.3632 - November 23rd 2016
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2226: SQL Data Compare will no longer display progress values greater than 100% during registration in the mappings UI
12.0.38.3582 - November 15th 2016
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- RGC-248: Licensing dialogs are more usable in High DPI mode
- SDC-2227: The select/deselect all button in the tables & views tab now only applies to visible tables.
12.0.37.3561 - November 10th 2016
FREQUENT UPDATES RELEASE
Strapline
10 - Bug fixes
Fixes
- SDC-2225: Improved cleanup of temporary files when deploying to scripts folders
12.0.36.3534 - November 7th 2016
FREQUENT UPDATES RELEASE
Strapline
40 - Better update notifications 10 - Bug fixes
Features
- Improved Check for updates UI - available updates are now a lot more obvious, there are more options for ignoring updates and the installation process has been streamlined
Fixes
- SDC-2176: SQL Data Compare will no longer insert/update rows in multiple batches of 8000 bytes
- On the tables and views mapping tab the label now shows the total number of columns correctly
12.0.35.3485 - October 31st 2016
FREQUENT UPDATES RELEASE Compatibility with SQL Compare 12.0.35.3485
12.0.34.3467 - October 26th 2016
FREQUENT UPDATES RELEASE * SC-9078: SQL Data Compare will no longer forget about columns being deselected when they are part of a mapping between columns with different names * SC-9062: Fixed an issue where SQL Data Compare could forget a selected revision number for a SQL Source Control data source when editing an already-compared project * SC-9061: SQL Data Compare now adds the SQL Source Control revision number to the deployment script comment header, if available * SC-9085: Fixed a bug where spaces could be appended to the end of multiline statements when saving a deployment script to a file * SC-9060: SQL Data Compare now allows arbitrary revision numbers to be typed into the SQL Source Control data source UI. * SC-9088: Typing in the database in the Edit Project dialog will now scroll to that database in the dropdown
12.0.33.3389 - October 17th 2016
- SC-7709: Improved usability on high DPI monitors
- SC-9059: Fixed a case where fetching the list of databases would fail when the server name contained custom connection string parameters
12.0.32.3340 - October 10th 2016
FREQUENT UPDATES RELEASE * SC-8998: SQL Data Compare now restores the main window position and size more reliably * SC-8959: Fixed an issue where SQL Data Compare would attempt to connect with the wrong credentials while loading the SQL Source Control revision number from a database * SC-9037: Double clicking on the comparison banner will now change the deployment direction * SC-8997: The deployment wizard button is now disabled if there are no differences to deploy * SC-9026: Fix exception on using the /out flag in the command line. * SC-9021: Projects created by the SSMS integration pack will now load your default options * SDC-2198: Improved display of deployment progress text in the deployment wizard * SDC-2210: The mappings UI now supports selecting or deselecting multiple rows using the mouse (previously this would only work with the spacebar) * SDC-2211: Some of the table layouts in the Edit Project dialog have been tweaked to make better use of space * SDC-2212: The UI now shows a spinny while generating a deployment script * SDC-2213: The UI now shows the deployment script in black while generating the syntax highlighting * SC-9044: Improved error handling on open file dialogs when a default directory can not be found * SDC-2215: The mappings UI now shows an icon next to tables with a WHERE clause specified * SDC-2216: Fixed an issue where underscores in table names in the progress dialog could get incorrectly interpreted as an accelerator key
12.0.31.3232 - October 3rd 2016
FREQUENT UPDATES RELEASE * SC-8409: Fixed a crash when failing to fetch encrypted object text * SC-8990: Fixed a crash when failing to list SQL Server instances
12.0.30.3199 - September 27th 2016
- SC-7709: Improved the appearance of the title bar in high DPI mode
- SC-9897: Fixed a crash when displaying a partially-formed source control location.
12.0.29.3182 - September 22nd 2016
FREQUENT UPDATES RELEASE * SDC-2207, SC-8878, SC-8879: Fixed a crash that could occur when using checksum comparison in some cases. * SC-8995: Allow source control as a source or target when using the command line * SDC-2206: Reduced memory usage of the deployment wizard for very large deployment scripts * SDC-2195: Fixed a crash in the project config dialog when right-clicking in the database dropdown * SC-9004: Custom connection string properties can now be passed by adding them to the server name on the connection dialog * SC-8955: SQL Data Compare now handles exceptions that occur while trying to set clipboard text while another application is locking the clipboard
12.0.28.3138 - September 19th 2016
- SDC-2021: Command line no longer fails when an excluded column is missing from a table in the comparison.
12.0.27.3125 - September 15th 2016
- The default file name for snapshots taken in the deployment wizard now contains a timestamp
12.0.26.3104 - September 15th 2016
FREQUENT UPDATES RELEASE * SDC-2202: Fixed a display bug in the differences grid which could cause wrong data to be displayed
12.0.25.3064 - September 13th 2016
FREQUENT UPDATES RELEASE * Improved performance of Data Compare data grid for tables with hundreds of columns * SDC-2194: Only enable Where clause on the Tables & Views tab of project dialog when tables have been selected. * SC-8970: Fixed spelling of “deployment” in the “Don’t use transactions” option description
12.0.24.3012 - August 25th 2016
FREQUENT UPDATES RELEASE
Fixes
- SC-8867: Pop up a message box to allow users to choose overwriting export directory
- SC-8936: Fix a bug where in the deployment wizard where the name and path of the sync script were being ignored.
- SC-8935: Add a timestamp to the filename for sync scripts to match the behaviour of SQL Compare 11.
- SDC-2187: WHERE clauses can now be bulk-added to multiple tables at once
- SC-8910: Fix a rare crash while loading the schema to edit the mappings
12.0.23.2976 - August 25th 2016
FREQUENT UPDATES RELEASE
Fixes
- SC-8922 Fixed viewing/saving/copying the deployment script when a text object uses nonstandard line endings
- SDC-149: Improved keyboard support in the lists in the mapping section of the project wizard
- SDC-2181: The deployment script comment header will now show the UI version instead of the compare engine version.
- SC-8907: Exclude spammy log messages caused by attempts to resolve resource assemblies
- SDC-2173: SQL Data Compare now correctly displays tables with names differing only by white space.
- SC-8642: Recently used projects are now added to the program jumplist in Windows 10
12.0.22.2910 - August 22nd 2016
FREQUENT UPDATES RELEASE
Fixes
- SC-8731: Fixed a graphical glitch in the Create snapshot dialog when backups were used as a data source but no backup files were selected
- SDC-2174: Support changing comparison direction on comparisons involving backup data sources
- SC-8620: Long error messages will no longer cause the “more details” dialog to be taller than your primary monitor
- SDC-2124, SDC-2125: Show ellipsis correctly when column or table name get too long in mappings window
- SDC-2185: The main grid row difference viewer now shows the correct tab when first clicked
12.0.21.2819 - August 16th 2016
Fixes
- SC-8235: Can now search and paste paths when opening folder locations
- SDC-2184: Maximum transaction size is now saved when changed in application options
- SC-8733: Display a message when there are no deployment warnings
12.0.20.2791 - August 11th 2016
Fixes
- SDC-2141: Restoring default column mappings will now make changes to the main table mappings tab.
12.0.19.2758 - August 9th 2016
Fixes
- SC-8900: Databases are now referred to as ‘source’/‘target’ rather than ‘first’/‘second’ throughout the application
- SC-8899: When changing deployment direction on a new project, any project open will not also change deployment direction.
- SC-8894: Prevented a NullReferenceException that could occur in the deployment wizard when a table was unmapped in the comparison.
- SC-8724: Display folder location rather than database name in the summary line of source control dialog
12.0.18.2723 - August 5th 2016
Fixes
- SC-8898: Fixed a bug that prevented swapping direction in the Edit Project window in some cases where a comparison had not yet been performed.
12.0.17.2708 - August 4th 2016
Fixes
- SDC-2179: The checkbox column in the Tables and Views mapping tab is now sortable
- SDC-1446: The arrow keys now navigate the data differences grid the same way as the navigation buttons.
- SC-8732: The ‘enter’ key now searches in the find box in the deployment script view.
12.0.16.2688 - August 3rd 2016
Fixes
- SC-8891, SC-8892: SQL Compare will no longer treat compatibility level 80 as a 2000 database when checking for deprecated versions.
- SC-8886: Open project dialog can now read both Compare and Data Compare project files.
- SC-8866: The progress dialog now gives a better indication of exactly which subtask failed, if any.
12.0.15.2659 - August 2nd 2016
Fixes
- SC-8880: Fixed a crash when copying/moving scripts folders in the connection dialog.
12.0.14.2614 - July 28th 2016
Features
- SQL Server 2000 databases are no longer supported.
Fixes
- SDC-1997: SQL Data Compare command line can now compare to source control targets.
- SDC-2171: Data Compare no longer shows two different Find boxes when displaying results.
- SC-8840: Fixed a bug where trials were reported as standard edition, causing the commandline to be unavailable
- SC-8849: Fixed a bug where the ‘deploy now’ button was greyed-out despite deployment being possible
12.0.12.2546 - July 22nd 2016
Fixes
- SC-8809: Mappings work consistently when deploying in either direction
- SDC-2162: SQL Data Compare no longer re-enables foreign keys at the end of the deployment script if the ‘Disable foreign keys’ option was selected and the foreign key was originally disabled
- SDC-2166: SQL Data Compare should now be more resilient against threading exceptions when browsing data in the differences pane
12.0.10.2453 - July 15th, 2016
Fixes
- All users are now eligible for a new 14 day trial
12.0.9.2436 - July 14th 2016
Fixes
- SDC-2108: You can use the left and right keyboard keys in the difference grid find control
- SDC-2167: It is now possible to map tables in different unmapped schemas
- SC-8791: Mapping two tables in the same schema when that schema is unmapped now keeps the mapping in the comparison
- SC-8803: Mapping two differently named tables when a schema is unmapped now keeps the mapping in the comparison
12.0.8.2363 - July 12th 2016
Features
- The product switcher has returned to Data Compare 12
- New login based licensing: see https://www.red-gate.com/user-licensing for more details
12.0.7.2257 - June 30th 2016
Fixes
- SC-8771: The UI executable is now called RedGate.SQLDataCompare.UI.exe as it was in 11.0
12.0.6.2193 - June 24th 2016
Fixes
- SC-8680: The application no longer has graphical errors when used in high DPI modes
- SC-8706: Source and target databases are correctly labelled in the deployment wizard when reversing deployment direction
12.0.5.2129 - June 20th 2016
Fixes
- SDC-2146: SQL Data Compare now supports viewing a deployment script for single object
- SC-8611: Cancelling the connection dialog window no longer results in mappings being saved
12.0.4.2107 - June 16th 2016
Fixes
- SC-8694: Deployment scripts now contain consistent line endings
- SC-8698: Copying a deployment script to the clipboard now result in the correct line endings
- SC-8644: SQL Data Compare will no longer allow the selection of invalid columns as part of a custom comparison key
- SC-8611: Changes to deployment options are now saved when a comparison is not required
- SC-8728: Make save, copy and search bar visible when loading deployment summary
- SC-4961: Moved the logging options to the Help menu instead of the system menu
12.0.3.2043 - June 10th 2016
Fixes
- SC-8686: Performance improvements for dependencies in the deployment wizard
- SDC-2150: It is now possible to select all or deselect all objects on the tables and views mappings tab
- SC-8717: More fixes for SQL Source Control detection where the list of installed applications is problematic
- SDC-2140: The unmapped objects section of the mappings UI is now expanded by default
- SC-8715: Improving font consistency: consolidating on Segoe UI
- SC-8721: SSMS 2016 has been added to the list of possible external editors
12.0.2.2016 - June 9th 2016
Fixes
- SC-8610: ‘Save project before closing’ dialog will no longer prompt for a filename if one is already known
- SC-8688: SQL Data Compare should no longer interfere with the taskbar auto-hide
- SC-8692: Text and interactive help fixes for the “Error parsing scripts” dialog
- SC-8693: SQL Data Compare should now correctly update the selected sql editor when changed from the deployment wizard
- SC-8655: Use latest icon for SQL Source Control
- SC-8684: Make SQL Source Control detection more robust when used as a data source
- Some high-DPI improvements for the differences and filter UIs
12.0.1.1977 - June 6th 2016
Fixes
- Minor tweaks to interactive help and database refresh buttons
- More validation and remote folder browser for backup options in the deployment wizard
12.0.1.1964 - June 3rd 2016
This is a beta release of SQL Data Compare 12, which brings a major UI refresh alongside support for major SQL Server 2016 features.
11.6.5.1976 - June 6th 2016
- Compatibility with SQL Compare 11.6.5
11.6.3.1926 - June 1st 2016
- Compatibility with SQL Compare 11.6.3
11.6.1.1686 - May 16th 2016
Fixes
- SDC-1356: Fixes a crash related to extremely large deployment scripts
11.6.0.1493 - May 9th 2016
- Compatibility with SQL Compare 11.6.0
11.5.8.1398 - May 3rd 2016
- Compatibility with SQL Compare 11.5.8
11.5.7.1288 - April 25th 2016
- Compatibility with SQL Compare 11.5.7
11.5.6.1198 - April 18th 2016
- Compatibility with SQL Compare 11.5.6
11.5.5.1107 - April 12th 2016
Fixes
- SDC-1418: SQL Further refinements when comparing an ntext field
11.5.4.891 - March 31st 2016
Features
- SQL Data Compare now connects to SQL Server 2016 RC1.
- New product switcher - accessible from the product logo top-left
11.5.3.659 - March 21st 2016
Fixes
- SDC-1418: SQL Data Compare no longer fails to compare some 100 collations when on an ntext field
11.5.2.509 - March 15th 2016
Features
- SQL Data Compare now connects to SQL Server 2016 RC0.
Fixes
- Trial licences will no longer expire instantly if upgrading from a previous version.
11.5.1.313 - March 8th 2016
Fixes
- SDC-1816: no longer crashes on startup if your MSI installed locations are corrupted or missing.
11.5.0.397 - February 29th 2016
Fixes
- SC-8313: SQL Compare no longer fails to register Azure v12 databases that have been upgraded around 25th February 2016.
- SDC-1744: Data Compare no longer introduces 0.0000001 second errors into DATETIME2 values
- SDC-1837: Data Compare no longer introduces 0.0000001 second errors into DateTimeOffset values
11.4.11 - February 15th 2016
Fixes
- SQL Data Compare can now register repositories from SQL Source Control when the SQL Source Control 5 Beta is installed
11.4.10 - February 8th 2016
- Compatibility with SQL Compare version 11.4.10
11.4.9 - February 3rd 2016
Fixes
- SQL Data Compare now has a SHA-256 digital signature.
11.4.8 - January 25th 2016
Fixes
- Fixed an error registering views on Azure SQL Database V11.
- SDC-2037: Fixed a crash selecting rows in the Row Differences pane.
11.4.7 - January 18th 2016
- SQL Data Compare now requires .NET 4.0 to be installed.
- Pivot view has been removed from the differences grid after a rewrite.
Fixes
- SDC-2014: Data Compare no longer inserts NULLs when deploying a script folder where column names weren’t specified
11.4.6 - January 11th 2016
- Compatibility with SQL Compare version 11.4.6
11.4.5 - December 21st 2015
Fixes
- SDC-2002: Fix an issue where
comctl32.dllcould potentially fail to load when SQL Data Compare is launched. - SDC-2007: SQL Data Compare no longer fills its log file with warnings when trying to connect to some versions of SQL Source Control.
11.4.4 - December 14th 2015
- Compatibility with SQL Compare version 11.4.4
11.4.3 - December 9th 2015
Note: Version 11.4 rolls up all of the changes from frequent update versions 11.3.1 to 11.4.3 - if you want to receive these kinds of updates more quickly in future, you should turn on Frequent Updates.
Fixes
- Fixed an issue where in certain circumstances it wasn’t possible to upgrade to the latest version of SQL Compare
11.4.2 - December 8th 2015
Fixes
SDC-2005: SQL Data Compare no longer fails when registering a SQL 2000 database due to querying permissions which do not exist on this version of SQL Server.
11.4.1 - December 1st 2015
Note: Version 11.4 rolls up all of the changes from frequent update versions 11.3.1 to 11.4.1 - if you want to receive these kinds of updates more quickly in future, you should turn on Frequent Updates.
Features
- SQL Data Compare will now warn when dynamic data masking (a new SQL Server 2016/Azure SQL Database feature) might cause masked data to be deployed. This warning appears when tables with data masks are selected in the source database and the user does not have UNMASK permission on the source database.
Fixes
From 11.4.0 * The default behaviour for disabling and re-enabling foreign key constraints has changed SQL Data Compare sometimes needs to temporarily disable foreign key constraints when updating data. When SQL Data Compare re-enables the foreign key constraints, it will now restore them to their original trusted or untrusted state by default, rather than always using WITH NOCHECK to skip integrity checks. This means that the constraints will no longer default to being untrusted, but the deployment will take longer because the integrity checks need to be carried out. The Force constraints to be re-enabled WITH CHECK option is now deprecated. If you want SQL Data Compare to continue to use WITH NOCHECK to skip integrity checks for foreign keys, select the new Skip integrity checks for foreign key constraints option. From previous 11.3.x frequent updates releases * SDC-1952: SQL Data Compare no longer freezes when you switch to a password field with the touch keyboard enabled in Windows 10. * SDC-1968: SQL Data Compare now preserves extended properties on foreign keys when the ‘Disable foreign keys’ option is selected. * SC-8005: SQL Data Compare no longer requires VIEW SERVER STATE permissions to register databases on SQL Server 2008 and later * SC-8023: All connection strings used by SQL Data Compare to connect to SQL Server now include the application name “Red Gate Software - SQL Tools”
11.4.0 - November 17th 2015
Fixes
- The default behaviour for disabling and re-enabling foreign key constraints has changed SQL Data Compare sometimes needs to temporarily disable foreign key constraints when updating data. When SQL Data Compare re-enables the foreign key constraints, it will now restore them to their original trusted or untrusted state by default, rather than always using WITH NOCHECK to skip integrity checks. This means that the constraints will no longer default to being untrusted, but the deployment will take longer because the integrity checks need to be carried out. The Force constraints to be re-enabled WITH CHECK option is now deprecated. If you want SQL Data Compare to continue to use WITH NOCHECK to skip integrity checks for foreign keys, select the new Skip integrity checks for foreign key constraints option.
