SQL Source Control 3.8 release notes
Published 16 July 2015
3.8.19 - July 8th 2015
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
Fixes
- SOC-6955: SOC no longer throws an exception when connecting to Analysis Services or Integration Services
3.8.16 - June 17th 2015
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
Fixes
- SOC-6666: Fixed error on unlinking
3.8.14 - June 3rd 2015
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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.11 - May 14th 2015
This version rolls up the changes from frequent update versions 3.8.3 to 3.8.10.
If you want to get updates more often, turn on Frequent Updates.
As of this release, SQL Source Control requires .NET Framework 4 or later.
Interface features
- New-look header bar, logos and About box:
- Brand new Setup tab, with options previously only configurable by editing text files:
- Brand new interface for editing comparison options in the Setup tab:
- 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
- "Select database to get started" message when no database is selected in the Object Explorer
Other features
- 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
- SQL Source Control is now listed in the SSMS Integration Pack add-ins tab
Fixes
- Fixed bug using non-active-directory authentication for the “Direct from source control” option in SQL Compare
- Fixed bug when handling objects with case-only difference in their name with case sensitivity option turned on
- Fixed invalid pointer that stopped SQL Source Control loading ("the add-in failed to load")
- 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
- Fixed repeated authentication prompts for some TFS URLs
- MIG-43: Migrations V2 can now detect and use LocalDB 2014
- MIG-6: Temporary database creation no longer fails on machines with certain regional settings
- Re-added "Throw exceptions on SQL parser errors" option to the comparison options (accidentally removed in previous version)
- SC-1196: Stored procedures that depend on a full text index can now be retrieved
- SC-6986: fixed “Data Compression not recognized” error for clustered columnstore indexes
- SC-7060: Now supports pass-through commands using EXECUTE syntax
- SC-7464: User-defined table types no longer cause duplicate extended properties
- SC-7647: Improved temporary file cleanup
- SOC-2010: Offline databases are no longer detected as having an old SQL Server version
- SOC-2865. Corrupt XML configuration files are now backed up and reset to their default rather than producing an error
- SOC-4366: InvalidOperationException no longer thrown in some circumstances when refreshing the Commit tab
- SOC-5179 and SC-6484: improved support for spatial indexes
- SOC-5450: The TFS link dialog no longer disappears when certain erroneous paths are entered
- SOC-6230: Fix error when opening SQL Source Control from the Object Explorer
- SOC-6260: Reduce instances of workspace locking errors
- SOC-6420: FileNotFoundException error no longer occurs when Connect project is present
- SOC-6423: Migrations V2 role membership now ordered correctly
- SOC-6487. Merging a stored procedure no longer drops the procedure when the merge output contains invalid SQL
- SOC-6488 and SOC-6499: TFS 2013 link/commit issues fixed
- SOC-6514: STDERR output from command line source control systems is now displayed when errors happen
- SOC-6515: Migration scripts no longer erroneously appears as an edit when there are no differences to commit
- SOC-6530: TFS file locks are now correctly lifted when a commit fails due to an unresolved conflict
- SOC-6535: Migrations V1 scripts can now be deleted when linked to TFS
- SOC-6584: "Could not find file" exception, which was hiding connectivity issues, is now suppressed
- SOC-6587: Running high display scaling levels in Windows no longer makes checkboxes in "Link/unlink static data" invisible
- SOC-6615: Changes to views with indexes with DATA_COMPRESSION="PAGE" are no longer detected as changes
- 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
- SOC-6650: Database icon in Object Explorer Details pane now has correct transparency
- 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
- SOC-6720. The SQL differences are now shown when viewing history of a branch in SVN.
- SOC-6734. The SVN link dialog window no longer disappears when certain erroneous paths are entered
- SOC-6746: Users no longer need to restart Management Studio when unlinking and relinking databases
- SOC-6748: Invalid SQL no longer causes runaway log file growth
- SOC-6777. You can now get latest when adding an extended property to a default schema
- SOC-6798: When the SQL Source Control History dialog window is opened from SQL Compare, the Select button is no longer misaligned with the Cancel button
3.8.10 - April 29th 2015
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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
FREQUENT UPDATES RELEASE
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.2 - January 13th 2015
This version rolls up the changes from frequent update versions 3.7.6 to 3.8.1.
If you want to get updates more often, turn on Frequent Updates.
Features
- Vault 8 support
- Added CaseSensitiveObjectDefinition option to the comparison options so users with case-insensitive databases can commit and retrieve case-only changes
- When getting changes to memory-optimized objects (SQL 2014), SQL Source Control warns you and temporarily disables transactions
- Improved error messages when the Migrations V2 beta fails to copy the target database
Fixes
- SOC-6230: Fix error when opening SQL Source Control from the Object Explorer
- SOC-6260: Reduce instances of workspace locking errors
- Fixed repeated authentication prompts for some TFS URLs
- Fixed invalid pointer that stopped SQL Source Control loading ("the add-in failed to load")
- SOC-5179 and SC-6484: improved support for spatial indexes
- SC-6986: fixed “Data Compression not recognized” error for clustered columnstore indexes
- SC-7464: user-defined table types no longer cause duplicate extended properties
- Fixed bug when handling objects with case-only difference in their name with case sensitivity option turned on
- Fixed bug using non-active-directory authentication for the “Direct from source control” option in SQL Compare
- 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
3.8.1 - December 18th 2014
FREQUENT UPDATES RELEASE
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