VersionSQL Changelog

v2.1.0 · VersionSQL_Setup.msi · 55,968 KB

Includes free trial of VersionSQL Professional

See what's new in VersionSQL

2.1 (2023-07-05)
- Connection settings import & export function
  - For sharing connection settings with the team or between databases
- Option to place the schema in the file name instead of a separate folder
  - Example: /Table/dbo.MyScript.sql instead of /dbo/Table/MyScript.sql
- Script indexes for indexed views in view script
- Per-connection Git author settings
- Azure DevOps connection setup prompts to enable third-party OAuth if necessary
- History window commit message summary line displays tabs and newlines
- Installer resets SkipLoading flag on reinstall
- Deploy script omitted stored procedure header comments
- FileNotFoundException during Git commit
2.0 (2022-12-05)

👉 Read the Road to VersionSQL 2.0 for more information and screenshots.
- Update 2.0.2
  - SQL Server Management Studio 19.0.2 support
- Update 2.0.1
  - SQL Server Management Studio 19 preview 4 support
  - Suggest possible solutions when the configured Git branch is not found
  - Exception when deploying from a folder to a database with no other non-Folder connections on the server
  - Failed notifications on pre-2014 versions of Windows Server disrupted VersionSQL's load process
  - Unable to detect SSMS installation in some restricted-permission environments
- History of Changes
  - See who made each change, when it was made, and what the old and new scripts were, all without leaving SSMS
- Undo Script Generation
  - Quickly and easily roll back changes made to the database schema
- Deployment Script Generation
  - Deploy recent changes from version control to a database or keep multiple environments in sync
- Dark mode
- Diff viewer
- New context menu icons
- Commit Entire Instance summarizes results
- Extended error handling
- Settings to control which operation states auto close
- Assembly conflict with another add-in
- Exception when committing a single table while other tables in the repo had extended properties
1.9 (2022-05-20)

👉 Read the VersionSQL 1.9 release notes for more information.
- Update 1.9.1
  - SQL Server Management Studio 19 support
  - SQL Server 2022 support
  - .NET Framework 4.6.2 support. Now requires a minimum of .NET Framework 4.7.2 installed.
- Branch Creation and Switching
  - Switch your database to target a different branch
  - Create new branches from existing branches
  - Pick from a list containing all the branches in the repo
  - Git-based repositories only
- Ability to specify remote branch during initial connection setup, before switching becomes available
- All scripts now include any extended properties present on the object
- Experimental option to commit the entire SQL Server instance at once (enable under global advanced settings)
- Connection setup now understands a wider array of Git URLs
- Blocks multiple simultaneous commits for the same database to avoid resource conflicts
- Trial status banner now updates immediately after license activation
1.8 (2022-02-15)

👉 Read the VersionSQL 1.8 release notes for more information.
- SQL Server Agent Job scripting
  - Connect SQL Server Agent to version control
  - Script out jobs to your repository
  - Build an audit trail of job changes
- Assembly scripting
- Commit reminder notifications
- Database trigger (DDL trigger) scripting
- Diff and merge presets for KDiff3 1.8+
- First-time onboarding is now a proper walkthrough rather than a screenshot tour
- Minimized context menu delay by pre-caching server information on connect
- Now detects and correctly handles case-only object renames
- Scripts now terminate with a line ending character
- Table scripts now include spatial and full-text indexes
- Commit shows a warning instead of an error if a table is deleted during scripting
- Contact form now drops out to the browser if an unusable proxy is specified
- File overwrite bug caused script fragments to remain if the script being committed was shorter than the one already in the repo
- Ignored objects are now excluded from batch scripting, not just from change detection
- In rare circumstances, a Git commit could be created with the timestamp of a previous commit
- Manual update check now shows a descriptive message if the update server is unavailable
- No longer attempts to push an empty Git commit if an error occurred while building the commit
- No longer writes to the error log when a diff started from the commit message prompt aborts due to missing configuration
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