Compare a repository revision, script folder, or database against a target database.
Review each difference side by side, pick the changes you want, and generate the deployment script.
Application role scripting and deployment.
Deploy Repo State to Database button on the uncommitted changes scan.
Object ownership (ALTER AUTHORIZATION) is scripted.
Redgate compatibility preset button.
Azure SQL Database deployment scripts are split into server and database sections.
Significant scan performance boost for databases with many extended properties or indexes.
SSMS database diagram objects are excluded from commits by default.
Undo lists dependent objects and rolls back on failure.
修正
Bitbucket OAuth sign-in failed with "Unknown OAuth error" on SSMS 20 and earlier.
Corrupt availability group names (KB5031908) could make connection settings disappear.
Git HTTPS sign-in error when using non-ASCII user names and passwords.
Overlapping scheduled commits reported wrong object counts in the commit message.
Scripts with double-quoted identifiers could lose their batch separators.
Static data export failed on SQL Server 2014 and earlier.
TFVC second batch could deadlock after an earlier commit failure.
VersionSQL v2.6.22026年6月8日
功能
Significant table-scripting performance boost for large databases.
修正
Data sensitivity classifications on table columns were not included in scripted output.
Object names with trailing whitespace could create unnecessarily long file paths; trailing whitespace is now trimmed, since SQL Server ignores it.
Permission statements could lose their GO batch separator in scripted output.
Saved credentials that could not be decrypted (for example after a Windows password reset or profile rebuild) would block operations instead of re-prompting.
VersionSQL v2.6.12026年4月27日
功能
Added native ARM64 installer for SSMS 22 on Windows on 64-bit ARM devices.
Minor table scripting performance improvement.
修正
Assembly version mismatches on SSMS 22.0 – 22.2 could prevent VersionSQL from loading correctly.
Clear Credentials did not erase the stored OAuth refresh token.
Dark mode now applies correctly to the VersionSQL flyout menu items in the SSMS context menu.
Extended properties on non-table objects could sort inconsistently between commits.
GO batch separators were added to trigger scripts even when the batch separator option was disabled.
Security policy scripting could fail on SQL Server versions that don't expose sys.security_policies.
Table scripting could fail on databases with unusually complex dependencies.
VersionSQL v2.62026年4月3日
功能
Security Object Scripting:
Version control for database users, roles, and schemas with permissions, role memberships, and security policies.
Redgate SQL Source Control compatibility mode with configurable folder layout and permission placement.
CREATE OR ALTER Scripting:
Opt-in setting uses CREATE OR ALTER syntax for scripts.
Supports procedures, views, functions, and triggers.
Requires SQL Server 2016 SP1 or later.
Added "Drop objects not in source" toggle in the Deploy dialog.
Added the option to disable OAuth authentication per connection.
History window shows rename operations in Git repository.
修正
Deploying from a different branch or revision could reset some connection settings to defaults.
Deployment script generator could pull non-static data scripts into the static data section.
Git push could fail with a null ref error when the tracked branch name differed from the remote.
Indexed view indexes were not scripted when batch scripting was turned off.
Leading slash or backslash in the Root Directory field caused commits to fail.
Repository list in the Deploy window could be out of date.
VersionSQL v2.5.12026年2月13日
功能
Added SSMS 22.3.0 compatibility.
Added Gitea and Forgejo OAuth authentication.
Added option to add GO batch terminators to scripts.