Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

SQL Source Control - Subversion - Switching

We branch our database often for requirements and version releases. Each version gets a tag which makes it easy to link to the proper version. When bugs come in we need to validate them. One of the steps that needs to happen is we need to make sure our database is on the same version that the bug came in for. The easiest way to do this would be to perform a subversion switch command to the tag in our repository for that version of database. It is very difficult to do this with SQL Source Control as it stands now. The only real way to do this is to unlink the database and then relink to the proper tag. In the background there is alot of deleting of folders and bandwidth to pull down the source again. With a switch it will only require the bandwidth for the changes not for everything.

8 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Shawn Raftery shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Al Higgs commented  ·   ·  Report

    We really need this too - I'm frankly surprised that switch is still not available over a year after the product was released. It would be great is someone from RedGate could confirm whether this is something that is going to be implemented?

  • Adam Tappis commented  ·   ·  Report

    We have a similar problem except it's even worse. We have 3 databases and we also developers in different regions. Going through this process for 3 DB's from a desktop in APAC connecting to a DB in London takes in excess of 1 hour! We have considered going down the route of writing a script which would:
    1. Close Management Studio
    2. Read & Edit the RedGateSource control XML config file
    3. Do an SVN switch on the underlying directories
    4. Restart Management Studio

    But really, the process should be made less painful from the UI. So really 2 changes that together would make our lives a lot simpler. Firstly support for switching from the UI and secondly support to do so for multiple databases

  • Martijn Laarman commented  ·   ·  Report

    Haste got the better of me:

    Make that switch: I'd like to be able to 'switch' from tags/1.0.0.0/Database to tags/2.0.0.0/Database...