SQL Source Control - 3.1
Setting up an SVN server - SQL Source Control
This topic provides a simple overview of setting up a Subversion server using VisualSVN Server, an installation and administration application for Subversion on Microsoft Windows servers. This topic does not address manual installation and configuration of Subversion, or installation on non-Windows servers.
For more detailed information on setting up a Subversion server, see:
- Chapter 6 of the Subversion documentation - Server Configuration
- Chapter 3 of the TortoiseSVN documentation - The Repository
Installing with VisualSVN Server
VisualSVN Server automates the setup of a Subversion server, and is available both as a free tool (the Standard Edition), and as the paid Enterprise Edition. The Enterprise Edition includes Integrated Windows Authentication, as well as richer logging and administration tools.
This example uses the free version.
To set up SVN, download and run the VisualSVN Server installer on the server you want to use, then follow the wizard to complete the installation.
You can download the VisualSVN Server installer here
VisualSVN Server provides an installation getting started guide
Page 4 of the installation wizard allows you to specify the location where the Subversion repositories are created, and the type of authentication:
Subversion authentication requires you to set up users and credentials on the Subversion server.
Windows authentication allows you to use your existing Windows user accounts.
Note that if you are using Windows authentication in VisualSVN Server Standard Edition (the free version), or Subversion authentication in either edition SQL Source Control may prompt you to enter your user name and password when linking a database source control.
At the end of the installation, run the VisualSVN Server Manager:
The Server Manager allows you to set up repositories and configure security.
To set up a repository to use with SQL Source Control:
- In the Console Tree pane, to the left, right-click Repositories, and click Create New Repository
The Create New Repository dialog box is displayed.
- In Repository Name, type a name for the repository.
Optionally, to create the recommended VisualSVN Server directory structure in your repository, select the Create default structure check box.
- Click OK
The repository is created.
Using the repository with SQL Source Control
To use the repository with SQL Source Control you will need to create a folder for your database.
To create a folder in the repository:
- Right click the repository, select New, and click Folder
The Create Folder dialog box is displayed.
- Specify a name for the folder, and click OK
The folder is created.
To link a database to source control, you need the URL for the repository.
To find the URL of a repository in VisualSVN Server Manager, right-click the repository, and click Copy URL to Clipboard
See also |
Was this article helpful?
Step by step examplesSQL 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
