SQL Source Control 3.8 Frequent Updates release notes
Published 15 May 2015
3.8.21 - July 22nd 2015
In this release, the object locking preview feature has been disabled. Object locking will be released as a full feature in SQL Source Control 4.
3.8.20 - July 15th 2015
Features
- Tooltip on hover for truncated strings on the Object locking tab:
Fixes
- SOC-6692: you can now view history when an object has been renamed in TFS
3.8.19 - July 8th 2015
Fixes
- SOC-4366. Stop spurious InvalidOperationExceptions
- SOC-6534: Now performs drop-only commits to Visual Studio Online without errors
- Arrow keys no longer tab out of the search bar
- Fixed caching performance regressions which appeared in SQL Source Control 3.8.13
3.8.18 - July 1st 2015
Features
Improvements to Object locking tab:
- "No locked objects in this database" displayed when you select a database with no locked objects
- Simplified text and layout
- Lines are now aligned with checkboxes
- Added delete button to search box
- Removed "X of Y objects selected" text
- Number of search results displayed next to search box
- Swapped Unlock and Refresh buttons
Fixes
- Launching SQL Source Control from a desktop shortcut no longer creates a temporary file on the desktop
3.8.17 - June 24th 2015
Fixes
- SOC-6955: SOC no longer throws an exception when connecting to Analysis Services or Integration Services
3.8.16 - June 17th 2015
Features
You can now lock objects you're working on so other people can't edit them. This means teams that share databases don't accidentally overwrite work.
This is a preview of a feature that will be released in SQL Source Control 4. When SQL Source Control 4 is released later this year, the object locking preview will be removed from SQL Source Control 3.
3.8.15 - June 10th 2015
Fixes
- SOC-6666: Fixed error on unlinking
3.8.14 - June 3rd 2015
Features
- Support for SSMS 2016 CTP2 (not including support for SQL Server 2016 CTP2)
Fixes
- SOC-6893: Migrations scripts (V1) are now picked up on Get latest
- SC-5151: XML schema collections that have additional child nodes are now detected as different
- SC-5533: Permission changes for system users (eg 'guest') are now ignored when the "ignore users' permissions and role memberships” option is selected
- SC-7896: When a service's queue changes, the deployment script no longer contains a duplicate ALTER SERVICE statement
- SC-7897, SC-7898, SC-7900, SC-7901, SC-7903, SC-7907: Square brackets in object names are now escaped in various remaining places
- SELECT statements containing a 'WITH (SNAPSHOT)' query hint no longer cause parsing errors
- Pressing N on the Setup tab no longer opens a new query window
3.8.13 - May 27th 2015
Features
- Filters now support the standard T-SQL LIKE syntax for wildcard characters (eg
%
,_
,[abc]
, and[^abc]
- see the MSDN documentation for more information).
To include wildcard characters explicitly in a filter, escape them with square brackets. "Equals" and "Does not equal" operators won't treat the characters as wildcard characters.
Fixes
- SQL Source Control no longer needs Management Studio to be restarted after bringing a database online
- SOC-6546: SQL Source Control no longer throws an exception when it's unlicensed or the trial period has expired
- SOC-2532: Filtering the character % no longer causes additional objects to be filtered
- SOC-3904: Filtering objects that begin with "_" no longer filters out all objects
3.8.12 - May 14th 2015
Fixes
- SOC-4635: TFS users should no longer receive the error "PendDelete returned an unexpected number of files"
- All child processes are stopped when SQL Source Control is closed
3.8.10 - April 29th 2015
Features
- Brand new interface for editing comparison options in the Setup tab:
Fixes
- SOC-6777. You can now get latest when adding an extended property to a default schema
- SOC-6734. The SVN link dialog window no longer disappears when certain erroneous paths are entered
3.8.9 - April 22nd 2015
Fixes
- SOC-6514: STDERR output from command line source control systems is now displayed when errors happen
- SOC-6798: When the SQL Source Control History dialog window is opened from SQL Compare, the
Select
button is no longer misaligned with theCancel
button
3.8.8 - April 10th 2015
Fixes
- SOC-6650: Database icon in Object Explorer Details pane now has correct transparency
- SOC-6748: Invalid SQL no longer causes runaway log file growth
- SOC-6746: Users no longer need to restart Management Studio when unlinking and relinking databases
- SOC-4366: InvalidOperationException no longer thrown in some circumstances when refreshing the Commit tab
- SOC-6515: Migration scripts no longer erroneously appears as an edit when there are no differences to commit
3.8.7 - April 7th 2015
Fixes
- Corrected scrollbar on the Setup tab
- SOC-6487. Merging a stored procedure no longer drops the procedure when the merge output contains invalid SQL
- SOC-2865. Corrupt XML configuration files are now backed up and reset to their default rather than producing an error
- SOC-6720. The SQL differences are now shown when viewing history of a branch in SVN.
3.8.6 - March 18 2015
Features
- Edit SQL Source Control options on the Setup tab:
These options were previously only accessible by editing a config file. - Access Edit filter rules and Link or unlink static data dialogue boxes from the Setup tab
- SQL Source Control is now listed in the SSMS Integration Pack add-ins tab
Fixes
- Buttons on the Setup tab now change color on hover
- Management Studio keyboard shortcuts now work on the Setup tab
- "Select database to get started" message when no database is selected in the Object Explorer
- SOC-6420: FileNotFoundException error no longer occurs when Connect project is present
- SOC-6530: TFS file locks are now correctly lifted when a commit fails due to an unresolved conflict
- SOC-6680/6681: When linked to TFS or Vault, the repository and folder locations are now shown on the Setup tab
- SOC-6686. SQL Source Control no longer reopens when Management Studio starts if it was closed last time you closed Management Studio
- SOC-6712: The revision number is now shown on the commit page after a successful commit
3.8.4 - February 25th 2015
Note
As of this release, SQL Source Control requires .NET Framework 4 or later.
Features
- Brand new Setup tab:
Known issue
- Management Studio shortcuts don't work on the new Setup tab
Fixes
- SOC-6615: Changes to views with indexes with DATA_COMPRESSION="PAGE" are no longer detected as changes
- SOC-6584: "Could not find file" exception, which was hiding connectivity issues, is now suppressed
- SOC-6626, SOC-6638: Databases with braces in the name no longer produce errors when you expand them in the Object Explorer
- SOC-6628. "Right-click database in Object Explorer -> Schema or Data Compare deploy -> Set as source/target" no longer throws an exception
- SC-7647: Improved temporary file cleanup
- Fixed issue tree conflict issue in SVN. This used to occur when committing a change that created a new folder that had also been created in the remote repository, and mostly affected SSDT users
3.8.3 - February 3rd 2015
Features
- Added new-look header bar and new logos:
- Removed the UseMigrationsV2 comparison option. The Migrations V2 beta is now enabled only using the UseMigrationsV2 engine option
- Linking to an SVN repository that contains lots of objects is faster
- Updated Vault client libraries to 8.0.1
Fixes
- MIG-6: Temporary database creation no longer fails on machines with certain regional settings
- SOC-2010: Offline databases are no longer detected as having an old SQL Server version
- SOC-6535: Migrations V1 scripts can now be deleted when linked to TFS
- SOC-6587: Running high display scaling levels in Windows no longer makes checkboxes in "Link/unlink static data" invisible
- SC-7060: Now supports pass-through commands using EXECUTE syntax
3.8.1 - December 18th 2014
Fixes
- SOC-6423: Migrations V2 role membership now ordered correctly
- SOC-6488 and SOC-6499: TFS 2013 link/commit issues fixed
- MIG-43: Migrations V2 can now detect and use LocalDB 2014