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. Work with a Visual Studio Database Project

    Can this work if I already have a VS Database project setup? Meaning can this work and interact with a VS Database project so that I can continue working on the actual db in SSMS, but the files get saved to the VS Db Project?

    196 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…)
      34 comments  ·  Flag idea as inappropriate…  ·  Admin →

      This is now available in the full release of SQL Source Control, http://www.red-gate.com/products/sql-development/sql-source-control, but it is still a beta feature.

      SQL Source Control can link databases to the most recent version of Microsoft database projects (those folders containing a .sqlproj file).

      It’s important to stress that this is a beta-quality feature, and as such it is only intended for experimental use. In particular, we are aware of some limitations regarding database-level extended properties, permissions and CLR assemblies. If you encounter these limitations or any other problems with this new SSDT compatibility, please let us know by using the Feedback link in SQL Source Control or contacting support@red-gate.com.

    • support for custom templates

      Ability to use custom templates, i.e. for table creation, to be able to add EXIST / DROP statements and permissions

      9 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…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • default password

        create an option to change the default password it uses when creating users

        3 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…)
          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
        • When unselecting a specfic item allow for unselect of dependent items

          If I unselected an assembly (since it is 32bit and I am x64) allow me a way to unselect all dependent objects easily. If I don't select an item I have a prompt to select dependecies but not the reverse.

          1 vote
          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…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Command line tool (or API) for SQL Source Control Integration

            We have an automated system for building our developer environments. It would be nice to have a command line tool that we can use as part of the machine build script to pull down the latest version of the database, build the initial database and link that database back to the TFS source. Our platform consists of quite a large number of databases so linking to them all manually via the UI is a bit tedious.

            208 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…)
              21 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • choose subfolders in subversion

              When adding a database to source control, all kinds of subfolders as created(data,assemblies,...) but these folder are not finegrained enough. for instance we do it by schema first then we use the same kind of subfolders.
              So if we have a Import and Base schema, then in subversion we have the procedure/functions folder under Import and under Base.

              It would be nice to be able to choose the folders themselves and also where to put a function and so on.. this gives more flexibility.

              3 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…)
                1 comment  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
              • Get Latest doesn't appear to work

                Backup a database which is under revision control (with SQL Source Control), modify an SP and commit it. Then restore the DB (rolls back the SP). Source Control see the changed SP and allows me to commit it, but Get Latest doesn't.

                3 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…)
                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                • Table Lock Escalation property change not detected

                  Changing the Lock Escalation property of a table in SQL 2008 SSMS is not detected as a change by SQL Source Control.

                  14 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…)
                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • Support Serena PVCS archive

                    We have used PVCS for 15 years for all our development source control. Is it possible to connect RedGate source control to a PVCS archive?

                    3 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…)
                    • bugid

                      Project management issue tracking software (Gemini, JIRA etc) use BugID to link checkins against issues. This allows for a managers to oversee progress on issues and other things (eg: risk of change, code review etc). The SVN BugID (a checkin property) is how a development code checkin is linked to an issue. Add this, and I can integrate our solutions easier at a CMMI level 3-5

                      35 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…)
                        3 comments  ·  Flag idea as inappropriate…  ·  Admin →

                        For now, enter your BugID into the comment field when you commit changes.

                        Please continue to vote/comment here if you would like to see a seperate Bug ID box like TSVN has. See James’ comment for more details.

                      • Auto complete changed object names in commit message

                        It would be very cool if this tool would auto complete changed objects in the commit message like TortoiseSVN.

                        6 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…)
                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                        • workspace per database, instead of per user account

                          At current we have SQL source control running in a remote environment. However, a DB - SVN link is stored for each user account, and is not transparent to the other developers.

                          Worse yet, with each developer having their own workcopy in their local profile, the same data will be duplicated several times. Also: conflicts will arise since each workspace updates on its own, while the DB might already be updated from another workspace.

                          Therefor: Suggest to keep 1 workspace per DB, to prevent issues of multiple workspaces or repositories linked to the same DB.

                          10 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…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • 12 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…)
                            • 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
                                I agree to the terms of service
                                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

                              • scary stuff when you minimal privileges

                                I recently connected to my database as a new user with minimal privileges (just data_reader). Later I went to SQL Source control to see changes (forgetting I was logged in as the restricted user) and the output was scary - every SP was marked as deleted and most tables were marked as edited (text replaced with 'encrypted').

                                I didn't have the courage to hit commit just to see what happened - it was too scary seeing my entire database marked for deletion!

                                3 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…)
                                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                • Change btn txt on the 'Get Latest' tab.

                                  Button says Get Latest. Incorrcet Subversion term. SVN Update or something similar will prevent the confusion.

                                  5 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…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Support SVN "Id" keyword

                                    We already maintain our database scripts in SVN (using Tortoise), and are very keen to change over to your product.

                                    We include the SVN keyword $Id$ in a comment at the top of every object file. When we commit, SVN automatically updates this to provide the Date, Author and Revision number of the last commit. This means that we're easily able to see which version of a particular stored procedure or function is in a client's database.

                                    SQL Source Control doesn't like this though. When I commit a change through SQL Source Control, the Id is updated by SVN, and…

                                    89 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…)
                                      9 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                      We’re currently not planning to support this for v1. Would you be ok to remove the $id$ keyword for now?

                                      We’ll have to see how many votes this suggestion gets…

                                      Internal reference number: SOC-113

                                    • Add "if exists...drop" option for programability objects

                                      Not everyone will want to use SQLCompare for continuous integration for various reasons. Adding an option to include an if exists...drop statement with certain types of objects means that all scripts can still be CREATE scripts while allowing for other CI implementations.

                                      27 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…)
                                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →

                                        For now, you may be able to use a batch file that executes SQL and drops the objects you want re-created before using the SQL Compare Command Line API. Since the objects are dropped, the synch script will generate CREATE scripts instead of alter.

                                        If you wanted to create everything from scratch, you could drop and recreate the database, which would generate all CREATE scripts.

                                        I hope this helps for now.

                                      • Automatically commit changes as they are made

                                        It would be nice to be able to automatically commit changes in the background when an object is created or modified.

                                        16 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…)
                                          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 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
                                            I agree to the terms of service
                                            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