SQL Source Control 7.0 release notes
Published 08 November 2018
7.0.50.9962 - November 13th, 2019
Improvements
- Updated SQL Compare Engine to 14.1.3.13805
7.0.49.9933 - November 5th, 2019
FREQUENT UPDATES RELEASE
Improvements
Updated SQL Compare and Data Compare to 14.1.1.13699
7.0.48.9916 - October 31st, 2019
FREQUENT UPDATES RELEASE
Improvements
The comparison option to "ignore performance indexes" can be set through the comparison options dialog
7.0.47.9910 - October 29th, 2019
FREQUENT UPDATES RELEASE
Fixes
SOC-9951: Unicode characters used as names now work correctly when committed to a git repository
7.0.46.9901 - October 28th, 2019
FREQUENT UPDATES RELEASE
Improvements
Updates SQL Compare and SQL Data Compare to 14.1.0.13605
Fixes
SOC-9965: The "Manually edit this script" option now appears when a conflict occurs.
7.0.45.9865 - October 22nd, 2019
FREQUENT UPDATES RELEASE
Improvements
Updates SQL Compare and SQL Data Compare to 14.0.8.13518
7.0.44.9821 - October 16th, 2019
Fixes
SOC-9966: The ordering for columns now exhibits the correct behavior.
7.0.43.9814 - October 15th, 2019
FREQUENT UPDATES RELEASE
Improvements
Updates SQL Compare and SQL Data Compare to 14.0.7.13398
7.0.42.9800 - October 10th, 2019
FREQUENT UPDATES RELEASE
Improvements
Updates SQL Compare and SQL Data Compare to 14.0.6.13317
7.0.41.9770 - September 30th, 2019
Improvements
- Updates SQL Compare and SQL Data Compare to 14.0.4.13211
Fixes
- SOC-9954: The warnings dialog no longer crashes when displaying warnings
7.0.40.9748 - September 23rd, 2019
FREQUENT UPDATES RELEASE
Improvements
- Updates SQL Compare and SQL Data Compare to 14.0.3.13103
Fixes
SC-10653: The history dialog no longer crashes when opened from SQL Compare
Object names are now displayed correctly in the Commit tab
7.0.39.9729 - September 19th, 2019
FREQUENT UPDATES RELEASE WITHDRAWN
Known Issues
- The object names are not displayed in the Commit tab
7.0.38.9718 - September 17th, 2019
FREQUENT UPDATES RELEASE
Updates SQL Compare and SQL Data Compare to 14.0.3.13033
7.0.37.9686 - September 9th, 2019
FREQUENT UPDATES RELEASE
Improvements
- Hashing algorithms are now FIPS compliant
- Updates SQL Compare and SQL Data Compare to 14.0.1.12901
7.0.36.9667 - September 4th, 2019
FREQUENT UPDATES RELEASE
Updates SQL Compare and SQL Data Compare to 14.0.0.12850
7.0.35.9625 - August 20th, 2019
FREQUENT UPDATES RELEASE
Updates SQL Compare and SQL Data Compare to 13.8.0.12547
7.0.34.9590 - August 13th, 2019
FREQUENT UPDATES RELEASE
Updates SQL Compare and SQL Data Compare to 13.7.23.1238
7.0.33.9556 - July 30th, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.21.12187
7.0.32.9539 - July 23rd, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.20.12076
7.0.31.9527 - July 18th, 2019
Features
Updates SQL Compare and SQL Data Compare to 13.7.19.11947
7.0.30.9490 - July 10th, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.18.11793
7.0.29.9469 - July 2nd, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.17.11635
Fixes
SOC-9916: Ensure we never select equal SQL Compare differences
7.0.28.9446 - June 25th, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.17.11492
Fixes
SOC-7176: Fixes an issue where very long warnings could cause an exception when the warning messages are shown when committing changes.
7.0.27.9422 - June 18th, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.17.11340
7.0.26.9397 - June 11th, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.16.11273
7.0.25.9378 - June 4th, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.15.11157
7.0.24.9343 - May 21st, 2019
Features
Updates SQL Compare and SQL Data Compare to 13.7.14.10918
7.0.23.9312 - May 14th, 2019
FREQUENT UPDATES RELEASE
Features
- SOC-9848: Fixes an issue when an .rgproj was present that would prevent importing or committing changes again until SQL Source Control was restarted.
Updates SQL Compare and SQL Data Compare to 13.7.13.10717
7.0.22.9288 - May 8th, 2019
FREQUENT UPDATES RELEASE
Features
- Added the ability to scroll the migration tab on low screen resolutions
Updates SQL Compare and SQL Data Compare to 13.7.13.10556
7.0.21.9273 - May 1st, 2019
FREQUENT UPDATES RELEASE
Features
- Updates SQL Compare and SQL Data Compare to 13.7.11.10438
7.0.20.9236 - April 24th, 2019
FREQUENT UPDATES RELEASE
Features
- Updates SQL Compare and SQL Data Compare to 13.7.10.10370
7.0.19.9216 - April 16th, 2019
FREQUENT UPDATES RELEASE
Features
- Updates SQL Compare and SQL Data Compare to 13.7.10.10286
7.0.18.9209 - April 10th, 2019
Features
- Updates SQL Compare and SQL Data Compare to 13.7.9.10145
Fixes
- SOC-9811: Fixes an issue with object locking where setting properties on some objects would use the wrong object name to determine if it was locked. This effects setting extended properties on columns and editing a table's Triggers, Stored Procedures, Indexes and Statistics. The locking setup script will need to be run again to update locking with the latest fixes, this will clear the locked objects table, unlocking all objects.
7.0.17.9125 - April 2nd 2019
FREQUENT UPDATES RELEASE
Features
- Updates SQL Compare and SQL Data Compare to 13.7.9.10117
Added a new project guid property to the RedGateDatabaseInfo xml file. This property will be used to track SQL Source Control usage across other Redgate products
7.0.16.9094 - March 26th 2019
FREQUENT UPDATES RELEASE
Features
- Updates SQL Compare and SQL Data Compare to 13.7.7.10009
7.0.15.9079 - March 20th 2019
FREQUENT UPDATES RELEASE
Features
- Updates SQL Compare and SQL Data Compare to 13.7.7.9928
7.0.14.9067 - March 15th 2019
FREQUENT UPDATES RELEASE
Fixes
- SQL Source Control will no longer show the message "Could not load file or assembly ICSharpCode.SharpZipLib" when using migrations
7.0.13.9055 - March 12th 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.5.9831
7.0.12.9030 - March 7th 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.7.5.9770
Fixes
SOC-9670: SQL Source Control will now show an error when linking if a bare git repository was selected
7.0.11.8918 - February 21st, 2019
Features
- Updates SQL Compare and SQL Data Compare to 13.7.2.9474
Fixes
- SC-8716: Changing the name of a default constraint now no longer unnecessarily drops and recreates indexes that reference the same column
- SC-10420: Adding a NOT NULL constraint to a column with a default constraint and an index will no longer fail deployment due to recreating the index before changing nullability
7.0.10.8879 - February 13th, 2019
FREQUENT UPDATES RELEASE
Features
- Updates SQL Compare and SQL Data Compare to 13.7.1.9280
- Adds a new comparison option to ignore sensitivity classifications on fields
Fixes
- SC-10382: Clustered columnstore indexes are no longer rebuilt when adding a column to a table and the "Ignore constraint and index names" option is set
- SC-10408: An exception is no longer thrown when updating a column from a type with no length to a type with length
- SC-10409: A duplicate index definition is no longer created when updating the schema of a temporal table
- SC-10393: SQL Source Control now supports the DATA_COMPRESSION keyword on spatial indexes
- SC-10397: SQL Source Control now sets the correct value for NATIVE_COMPILATION
- 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 exception
- SC-10382: Clustered columnstore indexes are no longer rebuilt when adding a column to a table
- SC-5024: SQL Source Control now reads the correct value for TRACK_COLUMNS_UPDATED from a scripts folder
7.0.9.8833 - January 25th, 2019
FREQUENT UPDATES RELEASE
Features
- Updates SQL Compare and SQL Data Compare to 13.6.12.8993
Fixes
- SOC-8848: Launching SQL Compare or Data Compare before SSMS no longer causes SQL Source Control to be disabled with the message "SQL Source Control is disabled because you have another Management Studio Window open".
- SOC-8849: When using SQL Source Control in multiple instances of SSMS, closing one instance of SSMS now correctly releases the lock on the selected database
- SOC-9317 (SC-10386): SQL Source Control no longer fails with an 'object reference not set to an instance of an object' error when working with FileTables (fixes regression introduced in 7.0.6)
- SC-10385: SQL Source Control no longer unnecessarily rebuilds graph tables when the "Force column order" option is set
- SC-10357: SQL Source Control now works correctly when queue alters contain POISON_MESSAGE_HANDLING statements
- SC-10157: we now deploy bound rule/default changes with UDT changes, so that incompatible rules and defaults no longer prevent use of the UDT
7.0.8.8807 - January 17th, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.6.10.8781
Fixes
SOC-9251: SQL Source Control no longer pops up an error dialog when the SQL in a file is invalid
7.0.7.8791 - January 10th, 2019
FREQUENT UPDATES RELEASE
Features
Updates SQL Compare and SQL Data Compare to 13.6.9.8643
Fixes
SC-10360: SQL Source Control will no longer throw an exception when a stored procedure ends in a SET ANSI_NULLS statement and certain options are set
7.0.6.8775 - December 21st, 2018
Features
- Improve error dialog on failed commit
- Add copy to clipboard button on some error dialogs
Fixes
Fixed the problem that caused some buttons in the SQL Source Control UI to be invisible in the first run after installation
SC-10339: Adding a column to a table with a history table no longer attempts to re-create an existing index
SC-10355: SQL Source Control can now handle more than one sensitivity classification per table
SC-10319: SQL Source Control now recognises primary keys on filetables so they can be referenced by other objects
SC-10321: SQL Source Control will no longer attempt to create an index on a view without dropping it when a related CLR assembly is being modified
SC-10336: Unique indexes on memory optimized tables can now be correctly committed without losing their UNIQUE property
SC-10351: SQL Source Control no longer fails to parse the PREDICT function
7.0.4.8725 - December 11th, 2018
Fixes
- Fixed issue when linking a new database results in an error 'Exception has been thrown by the target of an invocation' on Windows 8 and earlier, when SQL Prompt is installed and Git is not accessible.
7.0.3.8706 - December 6th, 2018
FREQUENT UPDATES RELEASE
Fixes
- SC-10262: SQL Source Control doesn't attempt to update default values in a non-nullable column before the default value has been added
- SC-10274: SQL Source Control can alter multiple computed columns that depend on the same column when altering the column type
- SC-10276: SQL Source Control handles altering the primary key while creating/dropping columns in a temporal table
- SC-9907: Don't generate an ALTER statement for a sequence which only has permission changes
- SC-10299: Double precision data types can now be parsed with a length parameter
- SC-10302: SQL Source Control can now parse stored procedures that manipulate security policies
- SC-10303: SQL Source Control no longer ignores permissions on domain users
- SC-10271: SQL Source Control now refreshes relevant views after unbinding user-defined data types from tables in order to safely modify the type
- SC-10311: SQL Source Control now respects dependencies correctly when a user defined type and a table have the same name
- Improve dependency handling for XML Schema Collections
- Fixed issue where Security Policy changes could not be committed properly
7.0.2.8677 - November 27th, 2018
Fixes
- Fixed issue causing a Win32Exception to appear when linking
- Fixed issue causing a Win32Exception to appear when pulling a git repository
7.0.1.8657 - November 26th, 2018
FREQUENT UPDATES RELEASE
Fixes
- SOC-9655: Fix regression when using SQL Source Control in SQL Compare
7.0.0.8628 - November 20th, 2018
FREQUENT UPDATES RELEASE
Features
- Support for pushing to TFS Git
- Support for SSMS 18
- Introduce Pre & Post-Deployment scripts. See http://www.red-gate.com/SOC7/pre-post-scripts for more details.
Fixes
- Various git fixes