SQL Source Control - 3.1

SQL Source Control

Migrating the evaluation repository - SQL Source Control

If you have been using an evaluation repository, or any local SVN repository, you can migrate it to a Subversion server, and retain all the log/history information.

You can migrate the repository by using VisualSVN Server, an installation and administration application for Subversion on Microsoft Windows servers.

VisualSVN Server 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 of VisualSVN Server.

The example has three steps:

  1. Download and install VisualSVN Server
  2. Import your evaluation repository
  3. Unlink and relink the repository in SQL Source Control

1. Download and install VisualSVN Server

To set up your SVN server, download and run the VisualSVN Server installer on your server, then follow the wizard to complete the installation.

For information on installing VisualSVN Server, see Setting up a Subversion server

You can download the VisualSVN Server installer here

2. Import your evaluation repository

To import the contents of an evaluation repository to your new SVN server, you must find the evaluation repository, copy the files to your server, and then import them using VisualSVN.

  1. First, locate the evaluation repository on your computer.

    The evaluation repository location is typically: C:\Users\<user name>\AppData\Local\Red Gate\SQL Source Control 2\EvaluationRepositories

    Alternatively, to find your repository location:

    Open SQL Server Management Studio if it is not already open. In the Object Explorer, select the database you want to import, and on the Setup tab of SQL Source Control, where it says Linked to, right-click the red text and click Copy:

    The repository location is copied to the clipboard.

  2. Browse to the repository location, and copy the repository you want to move to a location on your server.
  3. On the server, open the VisualSVN Server Manager if it is not already open, and in the Console Tree pane, to the left, right-click Repositories, select All Tasks, and click Import Existing Repository:

    The Import Existing Repository dialog box is displayed:

  4. In Existing Repository Location, paste the location of the repository copy.

    A new repository name is supplied automatically. If you do not want to use the default name, type a new one.

  5. Click OK.

    The repository is created. The new repository contains any history information from the evaluation repository.

3. Unlink and relink the repository in SQL Source Control

To start using the new repository with SQL Source Control, unlink the evaluation repository and link the new one:

  1. In the VisualSVN Server Manager, right-click the new repository, and click Copy URL to Clipboard
  2. In SQL Server Management Studio, ensure the database is selected in the Object Explorer, and on the Setup tab of SQL Source Control, click Unlink database

    A dialog box is displayed asking you to confirm the unlink.

  3. Click Yes

    The database is unlinked.

  4. On the Setup tab, click Link database to source control

    The Link to Source Control dialog box is displayed.

  5. In Repository URL, paste the URL of your new repository.
  6. Under Development Model, select your development model: dedicated, or shared.
  7. Click Link

    The database is now linked to the new repository on your Subversion Server.

See also

Setting up a local Subversion repository

Setting up a Subversion server

Using the evaluation repository

Linking a database to source control

Was this article helpful?

Search support
Forums
Visit the SQL Source Control forum.
Learning SQL Source Control
Knowledge base

SQL Source Control

all SQL products

all products

Notes & articles

SQL Source Control

all SQL products

all products

Demos & walkthroughs

SQL Source Control