How can we improve SQL Source Control?

Get specific version from source control (SVN: Update to revision)

Instead of Get Latest, I want to be able to get a specific version out of source control and reapply it to the database. This would allow me to rollback changes that were accidentally committed. I should be able to specify what version/revision that I want to go back to.

This is the same as getting a previous version from source control so that I can debug an issue a user found in a previous release.

169 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Red Gate AdministratorAdminRed Gate Administrator (Admin, Red Gate) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Philip FlynnPhilip Flynn shared a merged idea: Get version x instead of latest  ·   · 
    cgraefecgraefe shared a merged idea: update object to specific revision  ·   · 
    started  ·  Red Gate AdministratorAdminRed Gate Administrator (Admin, Red Gate) responded  · 

    SQL Source Control v1.1’s history dialog now works directly with SQL Compare Pro 8.50. Simply highlight the specific version in the history that you want and click the “Update to this version using SQL Compare Pro” button.

    A free trial of SQL Compare Pro is available at http://www.red-gate.com/products/SQL_Compare.

    The SSMS Integration Pack, which comes with SQL Compare Pro also allows you to deploy directly from SQL Source Control repositories.

    10 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • NathanNathan commented  ·   ·  Flag as inappropriate

        I was getting ready to provide feedback to suggest this same feature when I came across this article. It would be nice to have in SQL Source Control itself and don't forget to include the ability to bring in static table data saved with a revision. Please no extra tools, just keep it simpe. Rename Get Latest to tab to Get Changes. And then allow a dropdown to choose the revision with "latest" being the default. Would be perfect. Thanks for the great products.

      • Håkan BHåkan B commented  ·   ·  Flag as inappropriate

        I second Adara, Paul and Neil on:
        "This functionality should be in THIS tool, and not rely on the use of another RedGate tool"

      • AdaraAdara commented  ·   ·  Flag as inappropriate

        I agree with Neil and Paul that this should be available directly in SSC. Otherwise you might as well not sell it as a standalone. While SQL Compare is a great tool, it is a _separate_ tool, IMHO.

      • J. de GraafJ. de Graaf commented  ·   ·  Flag as inappropriate

        Will it also then included in de standalone version of SSC? From what I can see in the SSMS Intergration Pack it's a feature of the Integration Pack and not SSC directly. To have it directly available in SSC will be highly appriciated.

      • paul pricepaul price commented  ·   ·  Flag as inappropriate

        I'm going to agree with Neil. This functionality should be in THIS tool, and not rely on the use of another RedGate tool (even though I have it).

      • Neil BurnettNeil Burnett commented  ·   ·  Flag as inappropriate

        This is pretty vital for a revision control system:-) OK, so if there is data in the db then you are screwed, but I work with empty databases to make my changes then add unit tests creating the data for the tests as needed. In this scenario, I really need to be able to switch to another revision quickly and easily. I can use the workaround, but not in long term.

      Feedback and Knowledge Base