Skip to content

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

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

588 results found

  1. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History/Log  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. With 100s or 1000s of tables it becomes quite tricky to find objects in the static data link / unlink UI. Therefore, I suggest adding a search textbox there as well as making the UI columns (name, key, schema) sortable.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Static Data  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Hi - we use git in Azure DevOps. I have a few options for cloning,

    1. command line (which tbh i dont use much),
    2. 'git gui' - which is reliable and easy
    3. clone using visual studio from azure devops which doesnt work too much.

    it would be nice to be able to do the clone from the redgate sql source control GUI though

    ALSO

    When linking the database it would be nice to have a shortcut to

    c:\users\username\source\repos - this is where visual studio seems to default to and is a pain to browse to each time.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. would be really nice on the conflict screen if you didn't have to click up on the row then move mouse down to option button way at bottom, 185 TIMES! If you could just select a range and say 'take mine' or page down with arrow key and hit an F key F1 mine, F2 Theirs...

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. We use SVN with the config ". = svn:needs-lock=*" to automatically lock files on all our repositories (parameter in the config file of SVN on the computer of the developer).
    So a source file can be modified by only one developer at a time.
    It looks it’s a problem with SQL Source Control because the files in the local directory of the working databases are in read only.
    When I commit a change, I have the message “Do not have permissions to modify the file C:\Documents and settings...\Stored Procedures\dbo.PS_select.sql”.
    The commit is stopped.
    Of course, we would like to…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We currently do not support lock or exclusive checkouts (lock-modify-unlock model). We are supporting a copy-modify-merge model.

    In order to use SQL Source Control, you’ll need to use this model for now until we implement locking/exclusive checkouts in a future release.

    To do this, undo the change to the Subversion configuration file, remove the needs-lock property from any file in the repository, manually svn update the WorkingBases directory, unlink and then relink the db in SSMS.

    Depending on your OS, related files can be found in:
    C:\Documents and Settings\\Local Settings\Application Data\Red Gate\Logs\SQL Source Control 0
    or
    C:\Users\\AppData\Local\Red Gate\Logs\SQL Source Control 0

    1) Right click on WorkingBases\\Stored Procedures\dbo.PS_select.sql
    and select Properties
    *You can find the which corresponds to your db by looking in the LinkedDatabases.xml file.
    2) Select the “Subversion” tab at the top
    3) Click the “Properties…” button near the bottom
    4) Is there a svn:needs-lock property?…

  6. If user wants to run sql profiler, and doesn't want all of this background database activity there should be an option in Red Gate to pause the source control polling it is constanly performing on the linked database.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We currently don’t have an option to pause polling in the tool, but you can confiugre an XML file. Please contact support@red-gate.com for details. This file would need to be set for each user.

    You could also add a “Column Filter” in SQL Profiler’s Trace Properties’ Events Selection where “Application Name” is “Not like” “Red Gate%.” That should filter out the polling in your trace.

    I hope this helps!

  7. SQL Source Control tab should NOT be the DEFAULT on SSMS startup, Object Explorer Details should be the tab selected.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. TFS integrations really needs you to specify which workspace you are working with. This does wrong right from the start - when I try to link a database to TFS, it asks for the source URI and data folder, but it will only accept data folders already checked in, not that I have created in my workspace.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. It would be very cool if this tool would auto complete changed objects in the commit message like TortoiseSVN.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. if you work with several branches, it becomes kind of hard to keep track of everything, wouldn't it helpful to have a Source Control manager or something which shows all your branches and the databases connected to them.. then you can more easily make upgrade scripts between several branches if needed.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. If I could have the product walk a bunch of databases on a server (like a dev server) at 4 PM every day and check in any changes either completely automatically or with a single click for all dbs that would be sweet.

    Another use case for this is when I have to revoke a users rights to a bunch (20 or more) databases on a server with a script but then have to check in the change on each db one at a time.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. When working in an Agile environment I will have changes that need to be checked in for the current sprint while still modeling for the next sprint. I would appreciate a way to click on the "arrow" in the source control compare window to commit, for example, 1 out of 3 column changes in the Person table or a line change in stored procedure that coincides with 1 column change and leaving the other lines alone for the next sprint.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. I disable an index on an indexed view and source control doesn't detect the difference, but if I do script object as alter I see the disable line added.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. When comparing differences a double-click on the object could open a external diff viewer (if configured)

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  History/Log  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Include an objects history in SQL Doc.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  History/Log  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. I am suprised there is no SQL CE product considering the knowledge and skillset at this company. I think your prices are a little steep but I would pay a premium for a SQL CE Product providing it did the obvious. Just a suggestion and opinion. Nice existing products though.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Add "Author" and "Comment" attributes (from History window) to Get Latest display on SSMS. The Owner column is not very useful.

    I would like to be able to select defect fixes or specific enhancements to apply to a version of a database. For example, changes can be made by a developer in a DEV environment and checked into Source Control. Then the DBA can apply select changes to the TEST environment database for more testing. Select changes can then move forward to an INTEGRATION testing environment for a deployment test before moving to PRODUCTION.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. I am completely put off by Redgate taking over so much SSMS UI. I was very attracted to some of the tools, but can't work like this. Tried to find way to disable/hide them, but appears uninstall is only way.

    I want minimal UI intrusion until such time as I decide I like/want more UI intrusion. We need a way to dial it back to point where all redgate stuff optionally sits under single top menu and/or context menu.

    I reckon in meantime I will install tools in a throwaway VM so I can see how they work without impeding…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Add an option in the SSC filter to ignore differences in filegroup location as there might be multiple instances of a controlled database that have different filegroup configurations

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?