VersionSQL Changelog

v1.7.1 · VersionSQL_Setup.msi · 28,036 KB

Includes free trial of VersionSQL Professional

See what's new in VersionSQL

1.7 (2022-01-03)

👉 Read the VersionSQL 1.7 release notes for more information.
- Update 1.7.1
  - "No error message has been provided by the native library" when cloning
- Scripting Performance Boost
  - 5x faster scripting (on average) for tables, stored procedures, functions, and views
  - Significantly faster change detection
  - Lower SQL Server and client CPU usage
  - Streamlined commit progress report
- Advanced blacklist/whitelist (following gitignore spec)
- Prompt to trust git server self-signed certificates
- Settings search (in connection Advanced Options panel)
- Clustered table indexes now appear first in the table script's list of indexes, rather than mixed in alphabetically
- Context menu first load time reduced
- Git commit performance increased for large repos
- Progress dialog and cancel button responsiveness improved
- Availability Group detection no longer logs permission errors when users with limited permissions access a non-AG server
- Errors encountered while loading context menu items now display inline rather than in a dialog
- MSI silent install no longer opens thank-you page
- Progress dialog graphical glitches are resolved
- Windows folder reserved words are now escaped
1.6 (2021-06-01)
- Update 1.6.3
  - In-app contact form
  - Update toast notifications and update check frequency settings
  - Experimental batch table scripting was excluding some triggers
- Update 1.6.2
  - Experimental batch table scripting method with improved performance (enable under advanced options)
  - Trial period begins upon first use of non-free feature rather than upon install
- Update 1.6.1
  - GitHub organization access auto-detection and help prompts
  - Subversion folder-mode custom command presets
- Advanced Connection Settings
  - Change the root script directory name
  - Toggle whether or not to include the server name in the script directory path
  - Create custom commands for cli repository operations, with a few presets
- Native Subversion file lock and unlock commands
- Buffer progress log writes to improve responsiveness
- Commit would abort if denied access to a schema - now displays a warning instead
- "Directory not found" when the folder-type repository directory contained spaces
- "git clone" pasted into the repository path was being interpreted as part of the url
1.5 (2021-02-17)
- Update 1.5.4
  - More responsive commit dialog when committing thousands of objects
- Update 1.5.3
  - Friendlier error dialog
  - Show clearer messages during Open and Merge operations if the object doesn't exist in the repository
  - "An item with the same key has already been added" when enumerating cluster nodes
  - "Malformed URL" when pasted URL ended in a space
  - "NonFastForwardException" if another user pushed a change while the commit message window was open
- Update 1.5.2
  - Connection form sized incorrectly while displaying a notification
  - Long file name support
  - Settings save errored if access to the global .gitconfig file was denied
- Update 1.5.1
  - GitHub OAuth pulls Author information (and will request email address permissions in order to do so)
  - Clear Credentials operation did not clear GitHub OAuth authorization
  - "There is already an open DataReader associated with this Command" when connected to SQL Azure
- Authentication via OAuth
  - Log in to Azure DevOps, BitBucket.org, GitHub.com, and GitLab.com via a web browser
  - Supports two-factor authentication without the need to manually create access tokens
  - Cloud/SaaS only - 2FA on self-managed servers still requires a personal access token
- Select All option to quickly check/uncheck all objects in the commit list
- Prominent visual indicator of commit result
- Cross-database query error when connecting to SQL Azure
- Error connecting to SQL Azure with SSMS version 2016 or older
1.4 (2020-09-22)
- Update 1.4.4
  - GitHub OAuth support
- Update 1.4.3
  - Error loading settings dialog on new installations
- Update 1.4.2
  - Use Availability Group name in place of server name, if present
  - Server setting read performance improved by 90% on SSMS 2014+
  - Subversion full-database scripting performance improved by 45% (first-time) to 70% (repeat)
  - Subversion status log detailed messages
  - Cleaned out a bunch of unused code (I know you don't care, but it makes me happy)
- Update 1.4.1
  - Diff tool presets for Visual Studio and Visual Studio Code
  - Merge tool preset for Visual Studio
  - Diff and merge temporary files now use the .sql extension
  - Diff and merge tool detection
  - Commit dialog now resizes to fit very small screens
  - Folder-based commit deleted object detection
  - Rare issue causing update check to fail
- Write to folder + command-line operation
  - Folder repository type writes .sql files directly to the target folder
  - Optionally, enter a command-line operation to execute after the files are saved
  - Preset operations for Mercurial, Team Foundation Server (TFS), etc.
- Connection Setup corrects more types of incorrect input paths
- Git commit dialog now auto-closes upon successful commit
1.3 (2020-07-10)
- Update 1.3.9
  - NotFoundException: reference 'refs/remotes/origin/master' not found
  - Pressing enter on the path input field sometimes selected the Subversion repository type
- Update 1.3.8
  - FIPS compliance
- Update 1.3.7
  - High-DPI monitor support
- Update 1.3.6
  - Cancel button operation during Git commit
- Update 1.3.5
  - Merge tool presets for Araxis Merge and DiffMerge
- Update 1.3.4
  - Scripts with mixed line endings always showed modified
- Update 1.3.3
  - Git branch switching (in connection config file)
  - Personal Access Token support
- Update 1.3.2
  - Error when saved credentials contained an empty password
- Update 1.3.1
  - Git operations would freeze when the temporary files were locked by another process
- Open Latest and Merge operations
  - Open Latest loads an object's script from version control into a New Query window
  - Merge passes an object's scripts from version control and the database into a merge tool, then opens the result in a New Query window
  - Presets for popular merge tools KDiff3, WinMerge, Beyond Compare, and others.
- Diff operation shows progress dialog
- UDT scripting
- Git commit performance
- Crash on load if SSMS failed to supply context object
- Timeout while waiting for user to enter password
- New windows sometimes opened hidden behind SSMS
1.2 (2020-02-28)
- Diff operation in context menu
- Disconnect from Version Control function
- Git branch selection (in connection config file)
- Synonym and Sequence scripting
- Database scripting performance
- Error on non-standard Git default branch name
1.1 (2019-03-18)
- Update 1.1.9
  - Special characters in object names interfere with Subversion commit
- Update 1.1.8
  - SQL Server 2019 support
  - Additional shortcut keys in commit message dialog
- Update 1.1.7
  - Subversion checkout performance
  - Git checkout now normalizes line endings
  - Slashes in database name broke object parsing
- Update 1.1.6
  - Delete files from repository that no longer exist in database
  - SQL Server Management Studio v18 support
  - Diff tool preset for Meld
- Update 1.1.5
  - Diff tool presets for Araxis Merge, Code Compare, DiffMerge, and Meld
  - Unicode support in object names
  - Error if diff tool has been uninstalled
- Update 1.1.4
  - NTLM credentials were being used instead of saved credentials
- Update 1.1.3
  - TLS 1.2 support
- Update 1.1.1
  - Git operations would freeze when the temporary files were locked by another process
- Diff changes within commit dialog
  - Double-click a modified item to open third-party diff viewer
  - Presets for popular diff tools KDiff3, WinMerge, and Beyond Compare
- NTLM credential support
- Commit dialog hotkey support
- Commit dialog item sorting
- UI responsiveness during commit
- Auto update check failed to detect new updates