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

78 results found

  1. In the Source Control window I check severall objects and then, when I right click on Undo, a new window opens that only keeps one of the selected objects checked. And this new "Undo" window does not show code differences between DB and Source control. This forces me to Undo each object one at a time. Please keep all selected objects when using the Undo option

    3 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)

    This is already possible in the tool:

    It’s the row selections that are recognised by this feature. So you need to use Shift or Ctrl to select the items you’d like to undo, then right click and select undo. This will result in the entire selection being checked in the next screen.

  2. supporting SSDT projects with Redgate Source control will allow developers to use the tool of their choice (Redgate or SSDT) when developing database enhancements etc.

    12 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)
  3. By default, Source Control for Oracle creates the WorkingBases and Transients (along with other associated files and folders) in the users Windows profile (C:\Users<user name>\AppData\Local\Red Gate\Source Control for Oracle).

    In some environments the C: drive is configured to be minimal size (just OS and some required applications).

    Being able to configure the paths where the WorkingBases and Transients (along with other associated files and folders) would to free up disk space in environments where the C:\ is configured to minimal disk space.

    1 vote
    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. We like to track code reviews in TFS. Would like to have the ability to specify a code reviewer when I commit.

    36 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 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)
  5. Hello,
    We are using SourceControl with TFS2012.
    Sometinmes, when we commit our database, Redgate delete itself one ForeignKey of a table.

    We have not found why certain key and certain table are concerned...

    Tks for advance,
    GR

    3 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)
  6. 1 vote
    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)
  7. Please add version 9 support.
    Thanks.

    41 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. The source control 3 sql server 2016. but source control 5 + versions working fine.i have only source control 3 key.

    1 vote
    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. Your policy is:
    Your new password must contain:
    ◾At least 8 characters
    ◾At least 1 lower-case letter
    ◾At least 1 upper-case letter
    ◾At least 1 number
    ◾At least 1 special character

    Are you NUTS!?! Not even my bank requires all that. How about 3 out of 5.

    4 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)
    declined  ·  fiona.gazeley responded

    Thank you for your feedback. However I’m afraid the password policy to which you are referring is beyond Redgate’s control; it is dictated and enforced by Uservoice, a third party platform which we use for collecting, and responding to, feedback from users.

  10. I'd like the ability to filter unwanted databases out of the treeview in Object Explorer.

    I work with SQL instances which contain 100+ databases but I'll only be working with approx. 5 of them. It would save me a huge amount of time if only the databases I wanted to work with were shown.

    This would also be useful for anyone connecting to a SQL instance for shared web hosting as they'll likely only be interested in a single database out of the hundreds that would be listed in SSMS.

    4 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)

    This is already available in SSMS. (I think from v16+.) Just click the Databases folder in the Object Explorer and then click on the filter icon at the top of the Object Explorer to the right of the Connect drop down.

  11. We use synonyms when accessing data through linked servers. If the synonym is changed to use a new linked server Source Control does not detect that change.

    3 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  ·  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)
  12. Using Migrations V2:

    In one database, Developer A makes some changes, adds a Migration Script, and then checks in.
    In a second database (linked to the same source control location), Developer B makes some different changes and adds a different, unrelated, migration script. Now, before B checks in, they want to get A's changes. They go to the "Get Latest" tab, and they see that the Redgate.MigrationHistory TVF has conflicts and needs to be merged.

    The options are "Keep Mine" or "Take theirs", but neither of those will work because MigrationHistory needs to be merged. The "Merge" button won't work,…

    1 vote
    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)
    declined  ·  Elizabeth Ayer responded

    Hi Wesley, First of all let me apologize for the cursory decline. We really appreciate the thought you have put into this and the time you’ve given it with support.

    The reason we are not expecting to implement your request is that we are now taking a different approach with migrations. Please see http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/2299881-migrations-support-for-git-mercurial for more information.

    We would love to have you take a look at what we’re developing, though. Would you like to try out some merge scenarios with the new storage format?

    Best regards,
    Elizabeth Ayer
    Product Manager, SQL Source Control

  13. I get the message "Connect your databases to your source control system" yet I have selected the database. The video at http://www.red-gate.com/products/sql-development/sql-source-control/ is irrelevant as it assumes the software works.
    Not the best impression during evaluation.

    3 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)
  14. Need to deploy from Git Source Control Repository to Target Databases

    I use a shared Dev database and I work on multiple issues and versions of our software at the same time and am using Git to keep track of all the changes that go with each issue I'm working on. However, when QA asks me to deploy the changes relating to one specific issue to their QA environments, I have to manually go through all the changes in our shared database and determine which of the changes I made relate to that issue. In Git, I create a branch…

    14 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)

    These kinds of deployment scenarios are handled by SQL Compare (for manual deployments) or SQL Change Automation (for more automated/scripted deployments). SQL Source Control is intended for the dev side of your database change management process, linking your development database to a version control system.

  15. I created a Git hook to check the commit message format, when i place an improper commit message it fails to commit and then when i check for pending changes again I cant find those objects which failed causing an error due to commit message. How to resolve and get back my changes to be in place to commit.

    1 vote
    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)
  16. I realize that there is a request for the same in TFS, perhaps the different source control vendor doesn't make this a different request? In any event, we would like to shelve changes and we use Vault.

    2 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  ·  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)
  17. I understand a hook can be added to SVN so if a commit is made without a comment it will throw an error and fail - From an interface point of view it would be nice the commit couldn't even be made (i.e. the button was disabled if a "require comments" option was set).

    39 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 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)
  18. We desperately need the ability to supported gated check-ins so breaking changes do not get into source control.

    144 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. TFS lets the user "shelve" items before checking them in. A way to save them while they are still inprocess or not code reveiwed yet. It would be nice if SQL Source Control let us shelve the items instead of checking it in - with the same functionality we get when shelving through Source Control Explorer in Visual Studio.

    215 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. often when right-clicking an object in the Object Explorer, instead of seeing the menu, one of the SQL Source Control objects is 'automatically' selected and triggered.

    4 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)
    declined  ·  Elizabeth Ayer responded

    Hello! We’re going to believe that this was actually a hardware issue, not specific to SQL Source Control.

    If we’re wrong, please let us know, and we’ll be happy to reopen it!

← Previous 1 3 4
  • Don't see your idea?