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. 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)
  5. 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)
  6. 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.

  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. 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.

  9. 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)
  10. 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

  11. 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)
  12. 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.

  13. 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)
  14. 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)
  15. 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)
  16. 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!

  17. Oh, boy. At least after the last update (V 3.4.9.265) the function "View History" doesn't work anymore: it only displays:

    "No history available for this database"

    :-(

    0 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)
  18. 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)
  19. If "Commit changes" or "Get latest" tabs are currently refreshing, and you close all documents (Window menu, Close All Documents) SSMS 2008 Express crashes with the following details...

    Description:
    Stopped working

    Problem signature:
    Problem Event Name: APPCRASH
    Application Name: Ssms.exe
    Application Version: 2009.100.1600.1
    Application Timestamp: 4bb679e7
    Fault Module Name: msenv.dll
    Fault Module Version: 8.0.50727.1826
    Fault Module Timestamp: 480d6b43
    Exception Code: c0000005
    Exception Offset: 00316588
    OS Version: 6.1.7601.2.1.0.256.1
    Locale ID: 2057

    Read our privacy statement online:
    http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

    If the online privacy statement is not available, please read our privacy statement offline:
    C:\Windows\system32\en-US\erofflps.txt

    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)
  20. how can i re-enable code suggestions when i disabled it?the "Elable" button is disabled.

    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)
← Previous 1 3 4
  • Don't see your idea?