SQL Source Control 6.1 release notes
Published 31 January 2018
Before you update, please note:
SQL Server Management Studio (SSMS) 2008 and 2008R2 are no longer supported
Please note that SQL Source Control will continue to support SQL Server 2008 and 2008R2 - you will just need to connect to the server using a newer version of SSMS (2012 or greater). See End of support for SSMS 2008 and 2008R2 for more information.
6.1.8.7584 - May 23rd, 2018
Features
- Updates telemetry in accordance with the privacy policy available at https://www.red-gate.com/website/legal
Fixes
- SC-10080: SQL Source Control again ignores line endings whitespace in string literals when the
ignore whitespace
option is used.
In addition to the above fixes, version 6.1.8 rolls up all changes from versions 6.0.1 to 6.1.7. To receive these kinds of updates more quickly in future, turn on Frequent Updates
6.1.7.7560 - May 15th, 2018
FREQUENT UPDATES RELEASE
Features
- Bulk uninstaller improvements
Fixes
- Fixed a compatibility issue between different versions of Redgate products that could cause them to fail to load in SSMS 2014 and earlier
- SC-10050: Fixed an ObjectNotInDifferences error that occurred when the database contains a Service that depends on a Contract that is not defined in the database itself
- SC-10025, SC-10054: SQL Source Control now better handles the case when schema definitions are missing from the scripts folder
- When the Ignore event notification on queues option is used, SQL Source Control now correctly ignores extended properties on queue event notifications (as well as ignoring the event notification itself)
- Fixed a regression in the behaviour of the 'Ignore users' permissions and role memberships' option so that role memberships are now correctly ignored
6.1.6.7405 - May 1st, 2018
FREQUENT UPDATES RELEASE
Fixes
- SOC-7536, SOC-8358: Fixed an InvalidRemoteException error when using a Git repository with no 'origin' remote
- SOC-7351: Fixed an occasional "remote: internal server error" message when linking to a Git repository
- SOC-8354: Fixed one source of out of memory errors when getting the latest changes from a Git repository
- SOC-7338: Fixed one source of out of memory errors when linking to a Git repository
- SOC-8315: Fixed an intermittent "Short read of block" error message when getting the latest changes from a Git repository
- SOC-7584: Fixed an intermittent "Short read of block" error message when linking to a Git repository
- SOC-8508: Fixed "remote: internal server error Exception of type 'Sharpen.EOFException'..." error message when when getting the latest changes from a Git repository
- SOC-8370: Fixed one source of an intermittent "Cannot read file X:\\.gitconfig" error when using a Git repository
6.1.4.7353 - April 5th, 2018
FREQUENT UPDATES RELEASE
Fixes
- Fixed an issue that could cause high CPU load when the Redgate Client service was not running
- SC-9967: SQL Source Control no longer ignores whitespace in string literals when the "Ignore whitespace" option is set
SC-10016:
Fixed a bug where fulltext indexes on views with STOPLIST = OFF were incorrectly read from the linked databaseSC-9912:
SQL Source Control no longer crashes when scripting out a trigger it can't parse.- Event notifications now include the Service that they're on as a dependency
SC-9948:
Comparisons for a stoplist with NULL owner no longer crash.SC-10005:
SQL Source Control now treats EXEC and EXECUTE permissions as equivalent.SC-9873:
SQL Source Control can now read spatial indexes on computed columns where the function name has inconsistent casingSC-9991:
SQL Source Control can now parse unique inline indexes correctlySC-9987:
SQL Source Control now reads clustered columnstore indexes on computed columns correctlySC-9983:
SQL Source Control can now update security predicates correctlySC-9969:
SQL Source Control can now parse ALTER RESOURCE GOVERNOR RESET STATISTICS correctlySC-9985:
Dependencies between user-defined types are now correctly read from a snapshotSC-9975:
DateTimeOffset parameters are now read from scripts folders correctlySC-9953:
SQL Source Control now wraps the index name in square brackets when enabling or disabling an indexSC-9950:
SQL Source Control no longer incorrectly copies permissions and triggers between temporal and history tablesSC-9947:
SQL Source Control now correctly handles data compression on tables with clustered indexes
6.1.3.7298 - March 8th 2018
FREQUENT UPDATES RELEASE
Fixes
- SOC-9975: DateTimeOffset parameters are now read correctly
- SOC-9953: SQL Source Control now wraps the index name in square brackets when enabling or disabling an index
- SOC-9950: Fixed some spuriously copied permissions and triggers between temporal and history tables
- SOC-9947: Data compression on tables with clustered indexes is now read correctly
- SOC-9920: Fixed a bug deploying ALTER INDEX DISABLE and REBUILD
- SOC-9924: SQL Source Control no longer creates multiple copies of history tables
- SQL Source Control no longer creates SQL Server Authentication logins with insecure passwords
- SOC-9905: SQL Source Control can now rebuild tables with row-level security policies and predicates on them
- When a columnstore index is not supported in the target database version, the warning message now says whether it's clustered
6.1.2.7247 - February 22nd 2018
FREQUENT UPDATES RELEASE
Fixes
- Prevent a rare failure to retrieve license.
- SOC-9274: Handle a problem that could cause an out of memory exception when reading snapshots
6.1.1.7224 - February 16th 2018
FREQUENT UPDATES RELEASE
Fixes
SC-9919
: SQL Source Control doesn't create IDENTITY columns on the history table when creating a temporal table from a scripts folder.SC-9893
: SQL Source Control now correctly parses the units in a SET TARGET_RECOVERY_TIME statementSC-9836
: SQL Source Control now handles dependencies between user-defined type tables registered from live databases
6.1.0.7176 - January 31st 2018
FREQUENT UPDATES RELEASE
Fixes
SC-9857
: SQL Source Control now supports filegroups defined on a fulltext indexSC-9900
: SQL Source Control no longer duplicates index creation on history tablesSC-9909
: SQL Source Control now supports history tables with the same name but different schema to their related temporal tableSC-9859
: SQL Source Control now supports TEXTIMAGE_ON filegroup if it differs from the filegroup of the table