SQL Source Control

Welcome to the SQL Source Control feature suggestion list. Find out more information about SQL Source Control at http://www.red-gate.com/products/sql-development/sql-source-control/.

If you have any questions, need help or have found a bug in SQL Source Control, please review our support information http://redgatesupport.red-gate.com/home.

To get new features, performance improvements and bug fixes as soon as they’re available, you may want to turn on frequent updates: http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates

How can we improve SQL Source Control?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. ReadyRoll integration with Source Control

    ReadyRoll looks great but one of it's downsides is that you have to use Visual Studio. If mostly work gets done using SSMS, then switching to Visual Studio is not a great experience.

    Both ReadyRoll and SQL Source Control use the same comparison engines, they both output objects as files on disk and support migrations.

    To satisfy both worlds (making great experience when using Source Control on SSMS) and have a proper way to automatically update databases from source control files using migrations (like ReadyRoll does), SQL Source control should integrate with ReadyRoll - after each commit, a migration script…

    33 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      9 comments  ·  Flag idea as inappropriate…  ·  Admin →

      We’re starting to think about designs for how to make the migrations approach more accessible in SSMS. If you’d like to be involved in the research, please add a comment.

    • prevent timeout on commit changes tab for larger db in shared database model

      prevent timeout on commit changes tab for larger db in shared database model

      6 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        under review  ·  Paul Stephenson responded

        The timeout occurs when SQL Source Control runs a SQL query to find out which user made the changes that need to be committed, and the server takes too long to respond.

        SQL Source Control 3.6.0 improves this situation, so that if a timeout occurs you can still go ahead with the commit. This version is currently available on Frequent Updates. To learn how to turn on frequent updates, see: http://www.red-gate.com/products/sql-development/sql-source-control/frequent-updates

      • Migration Script Rollbacks

        The only obstacle I have with switching to SQL Source Control 3 as a complete solution to source controlling and deploying is its inability to rollback custom code in a Migration Script. I would like when creating a Migration Script the ability to create a Reverse Migration Script so that if I use SQL compare to roll a code push back to a previous version in source control, it will grab the reverse script the same way as it grabs the migration script currently when pushing.

        For example, if my migration script has an update statement in it to modify…

        92 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          4 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Validate Scheme - similar to VS for DB Pro "Build" e.g. dropping column on table will signal error

          Validate Scheme - similar to VS for DB Pro "Build" e.g. dropping column on table will signal error / warning on a view that uses that column.

          2 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • Provide ability to delete/drop objects from TFS / DB

            If from Get Latest / Commit changes it is determined that an object shouldn't exist, currently there is no way to drop the object from the db, or delete it from TFS, via the SQL Source Control UI.

            2 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Scroll beyond teh current page when seleting multiple items

              I can select multiple items by click/draging over the items, however it will only allow me to select what is on the current screen.

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →

                Do you have a wheel on your mouse? Once you highlight the items in view, just roll your mouse wheel to keep going down the list.

                Another way to do this is to click the first row, hold the shift key down, and scroll down to the last row and click again. This will allow you to highlight everything.

                Also, there’s a checkbox in the column header of the Commit/Get list if you want to uncheck/check everything all at once.

                I hope this helps.
                Stephanie Herr
                Project Manager SQL Source Control

              • Rename of objects containing [ not working

                I inadvertently put [] into lots of my column names and this broke RedGate. Google found something that might help explain:

                I eventually fixed it by dropping the tables, which caused RedGate to run a create table statement rather than sp_rename.

                https://connect.microsoft.com/SQLServer/feedback/details/509970/object-id-does-not-handle-object-names-with-square-brackets?wa=wsignin1.0

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                • Add ability to associate check ins with Work Items in TFS

                  Visual Studio already allows this which keeps track of which Source Control items go with which Change Control items. This would also be greatly beneficial if we could associate the database changes as well.

                  133 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    30 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    under review  ·  Elizabeth Ayer responded

                    Hi – this request was closed when the ‘TFS work items’ feature was released. http://documentation.red-gate.com/display/SOC3/Committing+changes

                    However, we’re still hearing about this enough that I’d agree with commenter Ben: it should be reopened.

                    We will continue to gauge interest here on UserVoice. Please do tell us more in the comments about what you expect to be able to do with Work Items in 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.

                    185 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      10 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      under review  ·  Elizabeth Ayer responded

                      We are considering this feature as a candidate for SQL Source Control 5.

                      You can still work around this by using SQL Source Control with SQL Compare Pro. Just 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.

                    • Error during applying changes to live DB

                      The error should consist more detailed data. Like from which procedure, function or table such error was thrown. I assume my error has nothing to do with SQL Source Control, it's my DB ;)

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                      • Don't see your idea?

                      Feedback and Knowledge Base