SQL Source Control - 2.1
Learning SQL Source Control - 2.1
Working with config files
‑SQL Source Control provides preset XML config files that enable you to automate source control operations for source control systems with a command line interface.
Commands in the config files
The preset config files include the following commands:
Get Latest
Updates the local working folder with latest version in source control.
Commit
Commits all changes in the local working folder to source control.
Add
Adds new files to the local working copy. Changes can then be committed to source control using the Commit command.
Edit
Makes the local working copy of the file(s) available for editing. Changes can then be committed to source control using the Commit command.
Delete
Deletes the file(s) from the local working copy. Changes can then be committed to source control using the Commit command.
Revert
Undoes changes if an error occurs during a commit.
Creating a custom config file
To create a config file for your source control system:
- On the Link to Source Control dialog box, click Manage Config Files.
- Open Template.xml in an XML editor, and specify commands and verification codes for the source control actions you want to automate.
Note: Ensure you specify the name you want to use for the config file in the <Name> tag. For example:
<Name>Darcs</Name>
- Save your changes as a new XML file in the default config files folder:
%USERPROFILE%\AppData\Local\Red Gate\SQL Source Control 2\CommandLineHooks
Your config file is now available to select in SQL Source Control.
See also |
Was this article helpful?
Worked example: Subversion (SVN)
Worked example: Team Foundation Server (TFS)
Worked example: Mercurial
Using SQL Source Control
Linking a database to source controlCommitting changesSource controlling dataGetting the latest versionViewing source control logs / historyGetting a specific versionDeploying a database from source controlUndoing changesConflictsUsing SVN bug IDs & TFS work itemsWorking with config files
Working with source control systemsContinuous integration
Bug reports and feedback
SQL Source Control
- Setting SQL Compare options within SQL Source Control
- "ICredentialsProvider is unset, therefore can't get" error occurring within SQL Source Control
- Linking fails due to SVN pre-commit hooks
- Logging changes to shared databases
- Object changed by Unknown
- Setting permissions for SQL Source Control
- Using SQL Source Control with Team Foundation Server 2012 or tfspreview.com
- Error: Failed to resolve no-ops after 5 tries
- Using SQL Compare or SQL Changeset scripts with SQL Source Control
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Source Control
- Database development models
- Release notes - version 1.0
- Release notes - version 1.1
- Release notes - version 2.0
- Release notes - version 2.1
- Release notes - version 2.2
- Requirements & prerequisites
- Technical Overview
- Release notes - version 3.0
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
