Settings that aren’t critical for getting started, but can be useful in certain situations.
Connection
Clear Stored Credentials
For Git and Subversion connections, removes any cached credentials for the current connection or path.
If you authenticated via OAuth, this will clear the token from VersionSQL’s cache. However, your browser may still log you in automatically from its cache. To log in as a different OAuth user, log out of your version control system from your web browser before clicking Clear Stored Credentials.
Disconnect from Version Control
Deletes the connection settings file from your computer. Note that if you click OK
on the connection settings dialog after disconnecting, the connection will be recreated.
Scripting
Root Directory
By default, VersionSQL creates a VersionSQL
subfolder inside your repository, and layers in the SQL within that. Use this setting to rename that folder.
Include server name and instance name in path
The default folder structure ensures that similarly-named databases across different servers are tracked independently without conflicts. If that isn’t relevant in your situation, or you want databases on different servers to share the same repo paths, uncheck this box.
- Checked:
root
/VersionSQL/pc_name
/db_server_name
/db_name
/db_owner
/object_type
- Unchecked:
root
/VersionSQL/db_name
/db_owner
/object_type
Batch table scripting for performance (experimental)
When this is enabled and more than one table is selected for scripting, VersionSQL will retrieve all table scripts in as few SQL queries as possible. In laboratory testing, this has improved commit speeds dramatically.
While the output of this feature looks good, it has not yet endured rigorous testing and is therefore marked experimental
.
Note: Unlike other settings in this dialog, this one applies to all connections.
Folder Repository Type
These settings only apply to connections using the Folder
repository type.
Auto-close after-save command
Automatically close the command dialog that opens to run the after-save command. If this is unchecked, the command dialog will remain open.
Custom Menu Commands
Allows you to specify any number of custom commands to place in the VersionSQL context menu.
Preset
Several presets are provided.
Menu Text
The text to display in the VersionSQL context menu. Clicking that text will run this command.
Command
The command to run. This can be quite powerful – check out the presets for inspiration.
Available variables:
- %filepath – Output script file path
- %dbpath – Output database folder path
- %rootdir – Output repository / root folder path
- %message – If present, prompts the user for a message
Auto-close command window
Whether or not to close the command once it’s finished running. If the command’s purpose is to provide information to the user, leave this unchecked.
Start commit from output
Kicks off the VersionSQL commit process using a list of files returned from your custom command. Useful for granular commits with custom logic, such as committing only locked files.
Script output should be one path per line, relative to database or repository root. If the path is not specific enough (e.g. just the object name), similarly-named objects may be pulled into the commit. Does not match objects that have been deleted from the database.