Can I use the same repository for VersionSQL as other software?
Yes! VersionSQL creates a
/VersionSQL/ directory in the repository, so committed SQL can coexist cleanly alongside other code.
Can I use the same repository for multiple databases?
Yes! VersionSQL places each database’s code into a separate directory.
Does VersionSQL support also Azure SQL Database?
Yes, VersionSQL Professional supports all recent versions of SQL Server. You can test it out for yourself by signing up for a free trial.
How do I remove a database from source control?
Right-click on the database in Object Explorer and select "Edit Version Control Settings". In the connection settings dialog click on the gear for advanced options, then click "Disconnect from Version Control". Press the
Cancel button to avoid saving the connection anew.
Can VersionSQL connect to my Git server?
VersionSQL can connect to any Git server that uses the HTTPS protocol whether onsite, off-site, via proxy, etc.
How do I connect to on-premises version control server using two-factor authentication (2FA)?
Please log into your version control server and generate a Personal Access Token (PAT) for VersionSQL to use. When VersionSQL prompts you for a username and password, enter the PAT as the password.
How do I select a different Git branch?
GUI support for branch switching is on the backlog, but until then you can set it manually by editing the configuration file. Navigate to the
%localappdata%\VersionSQL\connections folder, open the connection file in Notepad, then replace
<Branch>master</Branch> with your new branch name. Save the file. You will need to close all open SSMS windows and reopen SSMS for the change to take effect.
Does VersionSQL support Git over SSH?
VersionSQL only supports HTTPS connections natively, but can connect via SSH indirectly. Clone your repo to a local folder, then point VersionSQL at that folder and pick the Git post-commit command.