VersionSQL Changelog

See what's new in VersionSQL

• 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