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
  1. 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…)
    1 comment  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  2. Currently there is not easy way to see or restore a deleted object that was committed. The object code is still in Source Control - but no easy way to see or restore it using SSMS.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  3. Currently, SQL Source Control and SQL Compare have an option to "Ignore tSQLt framework and tests". We want to create our tests in dev and include them in our stage deployments for regression testing. The current setting ignores the framework AND our custom test code.

    We want the Red Gate tools to ignore only the framework, but not the custom tests. We will manage the framework install separately. Ideally, there would be separate ignore checkbox rule options, one for the framework and another for our tests.

    We have to set the current option to unchecked ("don't ignore") and then set…

    3 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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow for custom formatting used by SQL Prompt to also be used when committing code with SQL Source Control.

    119 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  5. When linking a 2nd (and all subsequent) database to Git - the text entry for the folder is locked (cannot type into it)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  6. On commit, there is a button to select/unselect all dependent objects. It would be good to have select/unselect basically a check box to tick or untick the dependent object. This will allow me to select specific dependent object I wish to control not all.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow object types same as that of SQL server database objects. Example, I would like to include some functions under "Table-Valued functions" under the object type "Function". It would be good if there is a tree structure for each object type same as that of SQL server database structure.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  8. With Amazon RDS, the server names are changed each time an instance is created. If a dev instance is recreated monthly, and a testing instance is recreated daily, it is impossible to keep the connection to source control when the server names change.

    The only way to get source control to work with our system is if it were able to connect to a static end point (dns record) rather than the server name itself

    3 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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  9. Someone in my team linked one of our test environment's databases to his source control. He was in a feature branch and just performed a "Get Latest" on the dB..... Now we have to reimplement the integrated changes. Please display the Server name in the setup window to avoid confusion and make sure this is clear.

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  10. 'Please ensure that the service is started. Click here for more information about this problem.'
    How about fixing this bug for when source control have forgotton its lic, which of course is fine . you can then try deactivating and reactivating, it says its is ok but nothing has changed. Would be so nice to be able to log on to your subscription, and tell it 'USE THIS ONE' so it can see on a redgate site what lic to use.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add a button to "Unlink, Delete my cache, Relink" so when support asks you to perform that function, it just takes the user 1 step.

    12 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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  12. This more a bug report than a feature suggestion. When i start Microsoft SQL Server Management Studio 10.50.2500.0 the fontsize is fine. But as soon as redgate loads the font size are changed.
    See here: https://stackoverflow.com/questions/40207918

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  13. If I exclude items from source control they should not default to be committed due to dependencies. It would be great if there was a setting when items are excluded to never include them in the list of items that are dependencies.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  14. SQL Source control is slowing down my entire SSMS. This wasn't always the case, but now trying to get a context menu to show up on a table can take up to 30 seconds. Please fix!

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  15. The SQL Source Control uses the default trace in SQL Server, however this is stored in the tempdb which can be cleared after a restart.

    RedGate suggest using a change log database as shown in the link here: https://documentation.red-gate.com/display/SOC3/Logging+changes+to+shared+databases

    However, this requires you to manually edit the Engine Options xml file in the user profile, this should be configurable in the UI making setup a lot easier. If you have 10 or more developers it requires that those developers maintain their own Engine Options xml file.

    It would be great if this is configurable through the UI on Setup when…

    2 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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  16. 4 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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  17. SQL Source Control tracks options like Default Collation. It would be useful to extend this to include all options that can be configured e.g. Recursive Triggers.

    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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  18. Could you please add a feature that would allow one to view the 'dependencies' when on the 'Commit to source control' window appears.

    This would be useful to see which of the tables you are about to commit relates to the 'dependencies' tables in the pop up.

    2 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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  19. Separate edit filter rule to ignore constraint names that define a default value for a column

    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  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
  20. No Category for BUGS? When comparing the TFS version to live DB in SSMS, objects missing from live DB don't cause the "change" visual queue. One must select the DB/SQLSource Control/Get Latest Tab to realize there are extra items in the DB. SQL compare does not have this issue.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Initial Setup  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?